Unable To Connect Second Computer To SQL Server Database
Aug 11, 2006
Hello all,
New forum member here, and pretty new to SQL Server. My question is I'm having an impossible time trying to connect MS Access on Computer A to a database running on SQL Server 2k (SP3) on Computer B. Every time I try to create a new ODBC connection on Computer A, I get the dreaded Server Error 17 (SQL Server does not exist or access denied). I have no problems making the ODBC connection on the computer running SQL Server (Computer B).
My connection settings are as follows:
Computer A name = MAINDESKTOP
Computer B name (contains SQL Server) = HOMELAPTOP
Workgroup name = WORKGROUP
Server Properties:
Name = HOMELAPTOP
Authentication = SQL Server and Windows
Registered SQL Server Properties = Use SQL Server authentication, and I'm using a login name and password
Server Network Utility = TCP/IP network protocol enabled, with default port 1433
Server Client Network Utility = TCP/IP network, default port 1433
Under "Security", I have created a new login using SQL Server Authentication called "bradley", and have assigned a password to the new login. I've noticed that when I open the login properties dialogue, there are always more ***'s in the password field than the number of characters I originally used, but I suspect that's normal. I have assigned a database called "Costume" to "bradley", and have verified that the permission is checked on the Database Access tab for user "bradley".
Under "DatabasesCostume", I have verified that there is a user called "bradley" with the same login name and user name.
No matter what I try, I can't get Computer A to connect to Computer B's SQL Server database. I have no problems with any other types of connections (pinging, internet, file transfers).
I thought I would post how I got remote t-sql debugging working in my environment. Hope it might help someone. I have two domains, DomainA and DomainB. DomainB has a one way external trust to DomainA. Dev Vista machine running VS 2005 is in DomainA logged in as user DomainAauser. SQL 2005 running on test Windows Server 2003 DC machine in DomainB under user DomainBuser. When trying to 'step into stored procedure' in VS, whether my data connection used windows authentication or sql server authentication, I would get the 'Unable to start T-SQL degbuggin...'. I could debug t-sql when I logged into the domain controller (console or rdp) and running VS on the server. I changed the SQL Server service to run under the DomainAauser account and I can now remote t-sql debug using both window authentication and sql server authentication. Hope this may help anyone that might run into this.
I am treating one of the XP Home system as 'Server' and installed SQL Express 2005 SP1. Enabled remote connections access.
I have total 4 XP Home systems, out of which one i am treating as Server, from the rest 3 computers, 2 are successfully connected to the Server and able to access SQL Express without any problems. But the 3rd system is unable to communicate with the Server. I disabled all firewalls in this 3rd system but still unable to connect to the server. I am able to ping the server, browse for shared folders on the server. Except SQL Express remote connection, everything else in the network is accessible from this 3rd computer.
Can anyone help me on how to troubleshoot this 3rd computer sql express connection problem to the server.
I don't have any error message to provide here. It just says, unable to connect to sql server, verify username/password etc.
Is there any limitation on SQL Express remote connections ?
hi, im making a log in using the asp.net web site admin tool the probably is when click n the security tab it says it cannt connect to the aspnetsqlprovider. thanksdomal
Hello all,I try to configure the website by using the built in tool of vs2005. When i click the button from Website -> ASP .NET Configuration.when the main page is displayed, i clicked the security, the error shows like:---------------------------------------- There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database.---------------------------------------How to enable connection to sql server? Thanks
To All Members,When I create a new project and try to use the ASP.Net web application administration :security tab, I get the following :There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. I am using Microsoft Visual Web Developer 2005 Express Edition with a local MS SQL Server 2000.I am new to all of this so a little help would be greatThanks.please mail me to dehackers@linuxmail.orgor izzuan@malysia.com
Hi, I am working through "Sams Teach Yourself ASP Dot NET 2.0 in 24 Hours" I am upto hour 20 where it says Configuring an ASP.NET Website to Support Membership To configure our website to support membership, we must launch the ASP.NET Website Administration Tool. To accomplish this, either click the ASP.NET Configuration icon at the top of the Solution Explorer or click the Website menu's ASP.NET Configuration option. Either way will open a web browser pointed to a page through which the ASP.NET site can be configured. Figure 20.1 shows the ASP.NET Website Administration Tool. To add user account support, click the Security link. This will take you to the Security screen shown in Figure 20.2. From this screen, you can specify the user accounts in your system, what roles for users exist, and the access rules for users. However when I click security I get the following error message; "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store." "The following message may help in diagnosing the problem: Unable to connect to SQL Server database." If I test the provider I get this error; "Provider Management""Could not establish a connection to the database.""If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider." I am using MS VWD Express with MS SQL Express. I have run the 'aspnet_regsql' tool on my database which the book fails to mention and verified that the tables were created correctly. I have tried copying the MDF file directly into my 'app_data' directory but this made no difference. I have googled these errors and nothing seems to help. I can connect to the database through a 'SqlDataSource' and have had no trouble with the database in the previous sections of the book. I think it may have something to do with how I setup SQL Express or database permissions, I hope someone can help. Thanks in advance. Here is a copy of my web.config; <?xml version="1.0"?><!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration> <connectionStrings> <add name="MyFirstDatabaseConnectionString" connectionString="Data Source=.;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMyFirstDatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" /> </connectionStrings><appSettings/> <system.web><!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. Visual Basic options: Set strict="true" to disallow all data type conversions where data loss can occur. Set explicit="true" to force declaration of all variables.--> <compilation debug="false" strict="false" explicit="true" /><pages> <namespaces><clear /> <add namespace="System" /><add namespace="System.Collections" /> <add namespace="System.Collections.Specialized" /><add namespace="System.Configuration" /> <add namespace="System.Text" /><add namespace="System.Text.RegularExpressions" /> <add namespace="System.Web" /><add namespace="System.Web.Caching" /> <add namespace="System.Web.SessionState" /><add namespace="System.Web.Security" /> <add namespace="System.Web.Profile" /><add namespace="System.Web.UI" /> <add namespace="System.Web.UI.WebControls" /><add namespace="System.Web.UI.WebControls.WebParts" /> <add namespace="System.Web.UI.HtmlControls" /></namespaces> </pages> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authentication mode="Windows" /> <!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors>--> </system.web></configuration>
HI all,I have hosted my ASP.Net application to a Hostingserver.My application fails to connect to the databaseserver, and promts error "Object refrence is not set to an instance of anobject"This Error is due to Drop Down Lists which query datafrom the database. I am using the connection string "Data Source=xxx.xxx.xxx.xx; Initial Catalog=shopadvizor;User Id=user1;Password=pass"The IP address above works fine when I Register andconnect the Remote database Srever with my Enterprisemanager. I can even query the database from my Local enterprise manager to the remote machine database server. Really Lost Need some help.Regards
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire,
The above was what I get whenever I tried connecting to SQL Server database. I've got Windows XP Pro SP2, IIS 5.1, and is currently using Visual Web Developer.
How do I rectify my problem of connecting to an SQL Server?
I have installed SQL Express 2005 on a Windows 2003 server. I am able to connect when I use "SQL Server Management Studio Express" However when i try the command: sqlcmd -S 127.0.0.1 i got the following error message:
"C:Documents and Settingsadm>sqlcmd -S 127.0.0.1 HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired."
when i click on ASP.NET Configuration and then security it opens a page that says There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database. tryed doing what it sayd but didnt go.
I am using one of the "Club Web Site Starter Kit with a template named: My Club Site.
Hardware: Dell Poweredge1300
Software: Windows 2003 Server
---------------------------------------- Details of failure
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) --- End of inner exception stack trace --- at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) at System.Web.Management.SqlServices.Install(String database, SqlFeatures features, String connectionString) at System.Web.Management.ConfirmPanel.Execute()
I recently installed VS2005 Prof edition and SQLExpress 2005 and have been teaching myself C# using the book
Microsoft Visual C# 2005 step by step.
I have done all the examples including the examples on databases without problems up to chap 27 which is trying to demonstrate adding security to a web site using the ASP.NET Web Site Administration tool.
After opening the tool and clicking on "security" the error message appears.
Unable to connect to SQL server database
As I understand it a database provider AspNetSqlProvider is supposed to create a database called ASPNET.MDF in the App_Data folder of the web site. Needless to say nothing is produced.
I have read various posts and done the following without success.
1 explicitly stated servr.exe as an exception in windows firewall
2 Run Aspnet_regsql at the command prompt. It bombs when I try to put a database name into the list box or even just click on the list box to see what it reveals. ( unfortunately I do not have the exact error but it sugested that it did not have read/write access to something
I do not really understand this . I am just an old fashioned amateur C++ programmer who thought he better get into the new world!
I get the following error trying to use ASP.NET configuration
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
If I try to run the application it starts up OK but it bombs when you try to put a password in because the database in App_Data has not been created.
Hi all, I'm new to .NET and VB2008 and trying to write my first database application. It runs fine on my development PC (Vista) but I decided to publish/install an early beta to my daughters XP computer and am getting an error reading: Unable to open database.
The CD drive on that pc has been giving us trouble so I deployed to a subdirectory on the dev pc and moved those files to a thumbdrive, copied to the same subdirectory on client pc and installed from there. I've installed it more than once, trying different paths for the installed version hoping that was the issue but have hit a wall. Can anybody help?
hi... i am new to ASP2.0 and i was trying to use the properties associated with the profile class. here what i was trying to do... in "Web.config" <anonymousIdentification enabled="true"/> <profile enabled ="true"> <properties> <add name="p1" allowAnonymous ="true"/> </properties> </profile> in "Default.aspx.cs" protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Profile.p1 = "Welcome"; LabelResult.Text = Profile.p1; } else{ Profile.p1 = "you'v been here"; LabelResult.Text = Profile.p1; } } but i had the exception ( Unable to connect to SQL Server database) at "App_Code.qzomymsu.0.cs" public virtual string p1 { get { return ((string)(this.GetPropertyValue("p1"))); } set { this.SetPropertyValue("p1", value); } } i know the problem has something to do with providers, and i want to store the values to an XML file.... thank you for helping.
Hi Eevryone: I seem to have corrupted my ASP.net Web Site Administration Tool some how. It worked fine a few days ago, but reloaded SQL Server 2005 Express Edition W Adv Services SP1 yesterday I can not get past the "Unable to connect to SQL Server database" error. I have run the aspnetdb.exe and created both a aspnetdb.mdf and loaded the tables to into a existing mdf. I have checked all the permissions. So any ideas on what I am doing wrong, or can you point me to some documentation on the 'AspNetSqlProvider'
Hi, I am trying to connect with Database.mdf(Server Express) which is inside App_data with my ASP.NET website but i am receiveing an error which i have pasted below. Initially i tried using a business Object(.xsd) but while specifying the datasource in DataSourceobject i got nothing using wizard(which lists all the Adapter Methods(insert,select) of my business object) hence i am trying to connect without a business object. i.e just using the connection string(ConnectionStrings:DatabaseConnectionString) but this results below Error. Kindly help:; ------------------------------------------------------------------------------------------ Server Error in '/MapSpeaks1' Application. -------------------------------------------------------------------------------- Unable to open the physical file "c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Unable to open the physical file "c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Unable to open the physical file "c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file c:inetpubwwwrootMapSpeaks1App_DataMapSpeaks.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735059 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
I would like to setup the membership and role in web administrator tool, however, under Security section, I got the error message of "Unable to connect to SQL database". I tried to run aspnet_regsql.exe to edit the config(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe), however, it still shows this error message. I am using web developer 2008 and SQL Server 2005. Please advice me how to tackle this problem.
We are unable to connect with Client SQL database server using VPN connection, even we are able connect with their intranet site.
We tried to connect using IP address, but no success. After that tried to ping that server with server name and IP address using command prompt, but got request time out error.
I was altering a few columns (setting to allow nulls) on a large table (30+ million records) and the machine naturally crashed. I rebooted, and now I can't connect to the DB - enterprise manager hangs, and query analyzer times out. is it likely the whole DB is screwed up, assuming the table alteration was incomplete?
thankfully, I do have a backup, but for future reference, is there a preferred way to make changes to large tables? last time I did this it took over an hour, and enterprise manager gives no progress indication to make me feel more comfortable that it's actually doing something...
I'm new to programing things, i'm on my own with MCAD/MCSD Amid Calani, i came to the point were i can"t go any further: i have VS enteprise architect,but i have only instece of SQL server,recently i downloaded SQLExpress , what should i do to connect SQL server to my computer, just because i'm new to to it looks stupid but maybe someone can HELP me with this. HELP, HEL,SOS,SOS...:eek:
I'have this error during install of Microsoft SQL Server 2005 Express Edition (x86). I'm Using Windows XP Professional with SP2 Build 2600. Does anyone knows how to solve this?
****
Microsoft SQL Server 2005 Setup was unable to install on your computer.
I just got a Virtual Dedicated Server and installed SQL Server Express 2005 on it and while I was installing choose Mix Mode authentication and setup a sa password.....
I want to connect to that database remotely from my machine using VS 2005 or Management Studio....both are encountering the same problems.....
On the Virtual Dedicated machine if I install management studio I run has no problem....it asks me for the server name : somethingSQLEXPRESS then username and password and works fine...
The same thing I try to do remotely is not happy with ....I tried to give the IP address of the server same thing no luck.....
Can somebody tell me what I'm doing wrong and where....
I just installed MSDE but when I try to connect to a database or create a new database I get the following message:"Microsoft ASP.NET Web MatrixUnable to connect to the database.General network error. Check your network documentation.ConnectionRead (rec()).TDS buffer length too largeTDS buffer length too large"Can anyone tell me how to correct this problem?Thanks,
i m having prob wiht connectivity to SQL Server Management Stdio Express. I am able to login thru only windows authentication. i changed setting to SQL authentication and windows both. i m creating the new login like security- logins - right click - new login- sqlauthentication and permission and all other opetion that i can checked i did but even though i m not able to connect. i have created a account from control panel and then try to do the same thign then it is giving me error that that login already excists. Plz help me here , it is driving me crazy. I am new in SQL Server plz help me out here.
Hi All!!! In my Computer has MS SQL Server 2000(with default Instance) and now I Install MS SQL server 2005(with Instance name: SQL2005 ). Now I want to write Web Application to connect to the both databases (SQL Server 2000 and MS SQL Server 2005), How to Add connection string in my web.config to do it. Help me ??? Thanks & Regards,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports I disabled windows firewall and antivirus (eset nod32) I installed all service packs available I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services Client Tools 2005.090.3042.00 Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840) Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.6001.18000 Microsoft .NET Framework 2.0.50727.1434 Operating System 6.0.6001
Hello All,I am using Visual studio.net framework 1.0 on win XP pro with MSDE. I am not being able to coneect to database using below code. can anyone suggest or have any idea what is going on? I have used all kinds of password and id. It doesnt pull data from DB. Really appreciate any help. Thank you in advance.
Sub Page_Load If Not IsPostBack Then Dim conNorthwind As SqlConnection Dim cmdSelect As SqlCommand Dim dtrCategories As SqlDataReader
conNorthwind = New SqlConnection( "Server=localhost;UID=sa;pwd=**secret**;Database=Northwind") cmdSelect = New SqlCommand( "Select CategoryName From Categories", conNorthwind ) conNorthwind.Open() dtrCategories = cmdSelect.ExecuteReader()
We have the issue of wanting to restore an MSSQL database (.BAK) but are unable to "Connect" to the existing database; but we are able to "Start" the database currently.
When we are unable to perform a "Connect", then under "All Tasks" you don't get the option to "Restore Database"
I am hoping there is a way around this and still a possibility of doing a restore without having to do an entire install of MSSQL again and then a restore?
I'm having a strange problem with this but I know (and admit) that the problem is on my PC and nowhere else. My firewall was causing a problem because I was unable to PING the database server, switching this off gets a successful PING immediately. The most useful utility to date is running netstat -an in the command window. This illustrates all the connections that are live and ports that are being listed to. I can establish a connection both by running
TCP 81.105.102.47:1134 217.194.210.169:1433 ESTABLISHED
TCP 81.105.102.47:1135 217.194.210.169:1433 ESTABLISHED
TCP 127.0.0.1:1031 0.0.0.0:0 LISTENING
TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51114 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51201 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51202 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51203 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51204 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51206 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1025 *:*
UDP 0.0.0.0:1030 *:*
UDP 0.0.0.0:3456 *:*
UDP 0.0.0.0:4500 *:*
UDP 81.105.102.47:123 *:*
UDP 81.105.102.47:1900 *:*
UDP 81.105.102.47:5353 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1086 *:*
UDP 127.0.0.1:1900 *:*
Both these utilities show as establishing a connection in netstat so I am able to connect the database server every time, this worked throughout yesterday and has continued this morning.
The problem is when I attempt to use SQL Server Management Studio. When I attempt to connect to tcp:sql5.hostinguk.net, 1433 nothing shows in netstat at all. There is an option to encrypt the connection in the connection properties tab in management studio, when I enable this I do get an entry in netstat -an, see below:
Amost as if it's trying the different ports but you get this time_wait thing. The error message is more meaningful and hopefull because I get:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)
I would expect this as the DNS has not been advised to encrypt the conection.
This is much better than the : Login failed for user 'COX10289'. (.Net SqlClient Data Provider) that I get, irrespective of whether I enter a password or not.
This is on a XP machine trying to connect to the remote webhosting company via the internet. I can ping the server I have enabled shared memory and tcp/ip in protocols, named pipes and via are disabled I do not have any aliases set up No I do not force encryption I wonder if you have any further suggestions to this problem?
Hi, iam using VS2008 for developing an application. From my code iam mentioning a connectionString in which iam using a database named ASAOPS.When iam trying to connect to it with a user named asauser it is throwing an exceptions that "asauser is not with the trusted sql connection" for one time and "login failed for the asauser" for later time. can anyone help me in solving this problem?
