Strange Remote Connect Issue
Apr 22, 2007
I recently switched servers and I'm running into the a really strange remote connection issue.
The server is brand new Windows 2003 fully updated , .NET 2.0 and 3.0 installed, trying remote connection using VS2005 and the full edition of Management Studio. Managment Studio Express is installed on box.
Firewall is not blocking UDP port 1434 or TCP port 1433 or any other normal port, verified with Netstats
First I tried to install SQLExpress Advanced Services as a default instance. The install worked fine with no issues. I enabled remote connections in the surface area config tool and then restarted the service. When I attempted to connect using xx.xx.xx.xxx or xx.xx.xx.xxy on the local machine using TCP or NP with SQL authentication it worked fine. Then I tried to connect from my remote machine and I recieved one of these errors:
Using TCP
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: TCP Provider, error:0- A Connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
Using NP
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)
Next I contacted my hosting company they recommended that I reinstall which I did this time as a Named Instance did the remote configuration, started the sql browser and got the connections working on the local machine using
.SQLEXPRESS
or xx.xx.xx.xxxSQLEXPRESS or xx.xx.xx.xxySQLEXPRESS
Tried again from my remote machine get the
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.Error 26 (can't find a server at this address error)
Any suggestions??
View 4 Replies
ADVERTISEMENT
Jan 25, 2006
I'm trying to connect to the SharePoint MSDE database from Windows XP
SP2 machine over Ethernet LAN. I was getting server not found or access
denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting
OK
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
I just did an netstat -an and I don't see the server listening on 1433.
What am I not doing?
The svrnetcn tool has no effect. I make a change and check the logs,
but nothing happens. What would be causing this?
View 4 Replies
View Related
Feb 16, 2007
Vendor app (written in VB '05) connects fine building screens that list data from only one record but blows up building 'list' screens that list multiple records. Really strange-it works fine when run locally on the server (Win2K3) and when run from one developer's machine (which has VS 2005 but not SQLExpress) but not from other developer's machines (which have both VS 2005 & SQLExpress) nor from a 'user' machine (which has neither). All have .Net Frameworks 2.0, the developer machines have SQL Management Studio & connect fine via that.
Vendor, of course, says it's a configuration issue so not their problem. I'm trying to figure out what they could be doing differently when building a list screen & therefore why it would fail. Fact that it works locally suggests that the failure is in the remote connection-but fact that it connects on 'single record' screens says that remote connections work. So what would be different about a request to return multiple records and why would it work locally but not remotely?
BTW, Surface Area Configuration Manager won't run-it reports 'localhost does not exist on the network or it cannot be configured remotely'. This is when running the Configuration tool directly on the server.
Any ideas?
View 2 Replies
View Related
Feb 28, 2008
Well this has got most of us stracthing our head as not matter what we do we can't connect remotely
But it get's a bit more complex. We have an existing web application running with a local instance of express running fine. However as the server is getting hammered we need to put the new version of the site on a second server. Unfortunately the key contact who use to work on the old system and set it up is no longer avialable. We've been through all the basics and nothing works... our latest attempt was to install a new instance of 2005 as we were not sure what was going on.
So, here is the log for this new clean instance:
Code Snippet
2008-02-28 15:12:13.75 spid5s Server name is 'S15271584SQLEXPRESS'. This is an informational message only. No user action is required.
2008-02-28 15:12:13.75 spid5s Starting up database 'msdb'.
2008-02-28 15:12:14.00 spid8s Clearing tempdb database.
2008-02-28 15:12:14.26 Server A self-generated certificate was successfully loaded for encryption.
2008-02-28 15:12:14.29 Server Server is listening on [ 'any' <ipv4> 4286].
2008-02-28 15:12:14.29 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalSQLEXPRESS ].
2008-02-28 15:12:14.29 Server Server named pipe provider is ready to accept connection on [ \.pipeMSSQL$SQLEXPRESSsqlquery ].
The Browser is up and running and we try to connect via SQL Management Studio with the following details:
SERVERNAMESQLExpress
SQL Server Authentication
But get:
Code Snippet
TITLE: Connect to Server
------------------------------
Cannot connect to SERVERNAMESQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
How do I know this is not a connectivity/firewall issue? Simple:
1. We stop the SQLExpress instance
2. Setup netcat to listen on that port (nc -l -p 4286)
3. Connect via telnet (telnet SERVERNAME 4286) and type something which then appears printed out on the other end.
Anyway, the Windows Firewall is off and I can't see any other firewalls installed (we did not setup this server).
Btw, if we try and connect to the existing instance we get:
Code Snippet
TITLE: Connect to Server
------------------------------
Cannot connect to www.a-t-s.net.
------------------------------
ADDITIONAL INFORMATION:
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10060&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Here is the error log for that instance:
Code Snippet
2008-02-15 06:43:16.92 spid4s Server name is 'SERVERNAMES15271584'. This is an informational message only. No user action is required.
2008-02-15 06:43:16.92 spid4s Starting up database 'msdb'.
2008-02-15 06:43:17.14 spid8s Clearing tempdb database.
2008-02-15 06:43:17.19 Server A self-generated certificate was successfully loaded for encryption.
2008-02-15 06:43:17.20 Server Server is listening on [ 'any' <ipv4> 1177].
2008-02-15 06:43:17.20 Server Server is listening on [ 'any' <ipv4> 1433].
2008-02-15 06:43:17.31 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalS15271584 ].
2008-02-15 06:43:17.31 Server Server named pipe provider is ready to accept connection on [ \.pipeMSSQL$S15271584sqlquery ].
2008-02-15 06:43:17.31 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2008-02-15 06:43:17.33 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2008-02-15 06:43:17.33 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
We've also run a network sniff with wireshark and get see the request hitting SQL on the right port... but there is never a response back.
Any ideas? I'm open to anything short of slitting my wrists!!
Many thanks in advanced.
View 5 Replies
View Related
Sep 24, 2007
Hello,I try to get an asp site to work on my local machine. Using ASP Studio2005 and mssql server 2005 eval on win xp, and ms management studio.I'm new to mssql and asp and just want to get the site to run (notedit). have a simple connect script likeset conn = server.CreateObject("adodb.connection")conString ="PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL;DATABASE=nano;UserID=sa;Password=yyy"conn.open conStringwhat happens is that IE hangs on load. the settings in the string areall ok I think: if I change id or pw (that is to any non-existinguser), immediately comes error like "problem logging in user sa". onlywith the correct values, IE hangs. this makes me believe that thesettings are right, but that the hanging comes from anything else. anyideas anyone? port problem? which is right? how to check? what else?how to detect? where are error logs? how to get detailed info?i would also be lucky with no-authentication - butconString ="PROVIDER=SQLOLEDB;DATASOURCE=DANIEL;DATABASE=nano;Integrated Security=SSPI"without uid and pw also results in hanging. so I now think the connstrings is ok. what is wrong?? [since I am new, and just took theproject from a cd, please also ask me "stupid"questions/suggestions!!] thank you VERY much!!!!daniel
View 1 Replies
View Related
Oct 29, 2005
Hey u guys.I have a strange problem and non of myfriends can solve it.The story is like this:I want to connect to my database at my hosting from SQL Query Analyser.With the same SQL server, username and password.But there is only me who can not connect by that way.This is the error of that problem, i made a screenshot for it.Please click here: http://www.xhnguyen.info/sql.JPGAnyone had this problem before ?Could anyone please help me solve it?Thank you very much.Joesy
View 1 Replies
View Related
Jan 30, 2007
Full Error message is:
Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
When I consult the error log I see:
Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-01-30 04:53:14.93 Logon Error: 17809, Severity: 20, State: 3.
_____________________________________________________________
The log error message doesn't make any sense because there aren't 4 user connections.
After I received the error message, mgmt studio still lets me access the database make changes, but I cannot connect via my application. Any ideas? Thanks!
View 8 Replies
View Related
Feb 8, 2007
Hi all,myDB is located atX:Program FilesMicrosoft SQL ServerMSSQLDatamyDB.mdfand my code is located at : C:Inetpubwwwrootapplicationfolderhow do I code my server.mapPath?
Btw, can I get VS 2005 to detect the server path when using server solution.Thanks
sub Page_Loaddim dbconn,sql,dbcomm,dbreaddbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("X:Program FilesMicrosoft SQL ServerMSSQLDatamyDB.mdf"))dbconn.Open()sql = "SELECT * FROM myTable"dbcomm=New OleDbCommand(sql,dbconn)dbread=dbcomm.ExecuteReader()myDB.DataSource = dbreadmyDB.DataBind()dbread.Close()dbconn.Close()end sub
View 1 Replies
View Related
Dec 28, 2005
If I already know that:
Domain: DM1
Server: SV1
Database: DB
user: u1
password: p1
How to connect to DB by Enterprise Manager ?
View 1 Replies
View Related
Dec 12, 2007
I have SQL Server running on a network and ACCESS db looks at it for the data. I have a computer in a remote office and I want to update my ACCESS db to look at that remote server. What do I need for it?
View 4 Replies
View Related
Nov 1, 2006
I’m going nuts and need some help with my ASP.NET 2.0 application which has trouble talking to a remote SQL Server 2000. First, before I describe my problem let me say that everything works perfectly on my XP development workstation when I point to the local SQL Server database. Screens load fine, saves and edits all work perfectly. Problem is when I connecting to SQL Server on a remote windows 2003 server I get Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Now, I’ve researched this error and have successfully made the following changes to the remote windows 2003 server where the database resides:1) Added logins for “ASPNET”, “NT AUTHORITYNETWORK SERVICE”, and “IIS_WPG”. The reason I added NT AUTHORITY is because we plan on deploying this web site to the same windows 2003 server and I understand that IIS6 (on this server) has ASP.NET running as NT AUTHORITY acct. 2) For all the logins above I’ve added them as users to the database and given dbo role. I still get same login for user null error when attempting to connect from my XP workstation. Can anyone help?
View 7 Replies
View Related
Nov 25, 2006
I recently reinstalled SQL Server 2005 on a new computer, and now I can't connect to remote SQL servers for some reason.
When trying to access the remote server with SQL Management Studio or DTS I get the following error:
-----------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) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476-----------
I'm certain the servers I'm trying to connect to allow remote connections so the fault must be on my side. Does anyone have any idea what the cause and solution might be?
View 5 Replies
View Related
Dec 6, 2003
How can I connect to a online SQL Server with Enterprise Manager?
View 3 Replies
View Related
Mar 14, 2004
Im the new in ASP.net.
I find no way to connect remote datebase(sql server 2000).
Everybody who have ways help me.
Thank you!
View 3 Replies
View Related
Feb 28, 2005
hey i created a client app.. i want to connect it to a remote db.. but i am not able to connect through the internet. but its working for LAN.
is there anything that i must change in the settings of the enterprise manager??
i am connecting through an sa password and i allowed other sql servers to connect remotely to this sql server using rpc...
i am using this code to connect . i am using vb.net
"Data Source=x.x.x.x;Network Library=DBMSSOCN;Initial Catalog=test;User ID=sa;Password="
View 6 Replies
View Related
Apr 18, 2007
Hi Folks I have faced a problem during my application development... The application which is manipulating data in SQL sever 2005 which resides on server Named [Mserver1]... Now in the local netwrok there are 10 Client Pcs... My application will be running on all of them... What connection string will i use for that.. Client Pcs have not got SQL on them... I am using visual studio 2005, SQL server 2005.
Any help ??
Thanks in advance
View 1 Replies
View Related
Jan 24, 2008
Hi, I have Windows XP Pro OS with SP2 and SQL Server 2005 installed.
I want to give Windows Authentication to my colleague sitting next to me, we are into same LAN. Is it possible to give access to my friend and if so can I create a seperate Security Group and add multiple users to them and give access.
-Senthil
View 3 Replies
View Related
Jul 23, 2005
From Enterprise Manager on my PC, how do I connect to a remote server overthe internet - I have the IP address, User Name and Password.Thanks
View 2 Replies
View Related
Jul 20, 2005
Hello,First, sorry for my bad English.Here is my problem:BoxA: XPpro + Apache + php (using php_mssql.php)+ ADOdb + MS SQL Server+ My_Prog (using local MS SQL PUBS database)BoxB: NT4 + Apache + php (using php_mssql.php)+ ADOdb + My_Prog (usingremote BoxA PUBS database)BoxC: W2KMy_Prog uses:$serveur = '10.0.0.1'; BoxA's IP address$admin_nom = 'sa';$admin_mdp = '';$base = 'PUBS';$conn = &ADONewConnection($sgbd);$conn->debug = true;$a = $conn->Connect ($serveur,$admin_nom,$admin_mdp,$base);From BoxC, using IE, connecting to:- BoxA My_Prog : I access PUBS, that's OK- BoxB My_prog : "Warning: mssql_connect(): message: Echec de laconnexion de l'utilisateur 'sa'. Raison : Non associé à une connexionsécurisée SQL Server. (severity 14) in ...adodb-mssql.inc.php on line438." (I prefer to report the "French" message)Anyone knows about ?Thanks in advance,Eric
View 1 Replies
View Related
Aug 22, 2007
Hi All,
I have created my sql database script using SQL data publishing wizard, now i want to execute the same on my shared hosting database. But i am not getting any option to connect to remote server in SSMSE.
I have developed web based application with back hand as SQL Server 2005, so now i want to execute my script file onto the server. so how i will connect with my server using SSMSE ?
My application is located under www.briskonsales.com/sales
Any idea ?
Thanks,
Jay
View 5 Replies
View Related
Oct 18, 2007
I am unable to connect to a remote instance of SQL Server to which I have full permissions. Names Pipes are enabled and started. All services appear to be running. The server uses windows authentication and has the domain admin account referenced.
The follwoing is the response on attempting to connect:
An error has occurred while establishing an error to the server. "....this failure may be caused by the fact that under default settings of SQL Server does not allow remote connections. (provider: Named Pipes provider: error 40. could not open a connection to SQL Server IMS SQL Server error 53)"
Any help is apprecaited
View 5 Replies
View Related
Dec 15, 2005
I just installed the 90 day VS2005 Professional Edition - prior to this I was using VS2005 Beta 2 -
I have a database on a remote server that I have been using in VS2005 Beta 2 with no problems - In VS2005 Beta 2 I succesfully ran aspnet_regsql against this database and set up connection strings in the Web.config file and everything ran fine.
Now after installing VS2005 ( I re-installed Windows XP Pro to make it a clean install - this has not been a short process ) anyway the same projects are not working in VS2005 90 day edition
I get the error
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)
I tried enabling TCP/IP and named pipes in the server manager but no luck
thanks
View 5 Replies
View Related
Oct 10, 2007
Hi
I am trying to conect to a remote database using SQL Management Studio Express from inside a LAN but get an error message indicating that the server does not accept remote connections. However, I can connect with no problems from outside our LAN. I am looking for suggestions on how to resolve this issue
Bob
View 3 Replies
View Related
Jul 29, 2007
I wnat to connect to remote sql server 2005, I do the following steps:
Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.
sp_addlogin 'Wind','ack@123','db'
but still can't login,tips as follwing:
Login failed for user 'Wind',The user is not associated with a trusted SQL Server connection.
Error:18452
Why? Must use "SQL Server Authentication" connect?
View 1 Replies
View Related
May 15, 2008
I have 2 Window 2000 servers. A server is a Web server (IIS 5.0). B server is a MS SQL 2000 database server.
I use the following connection string to connect successfully the B DB server from the A server.
....
cnstr = "Provider=SQLOLEDB;Persist Security Info=False;UID=xxxx;PWD=xxxx;Data Source=xxx.xxx.xxx.xxx;Initial Catalog=DDDDD;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open cnstr
......
But, I change the connection string to the following (it just only be added "Network=DBMSSOCN;", it is connecting with TCP/IP). It is failed !
....
cnstr = "Provider=SQLOLEDB;Persist Security Info=False;UID=xxxx;PWD=xxxx;Data Source=xxx.xxx.xxx.xxx;Initial Catalog=DDDDD;Network=DBMSSOCN;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open cnstr
......
The error message is :
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).] General network error.Check your network document
/TCPIP_Test.asp, line 14
Then, I use the same connection string (TCP/IP) to connect successfully the B DB server from an other C web server.
Other test on the A server :
1. ping -a <B server> : test OK !
2. telnet <B server> 1433 : test OK !
3. osql -U<xxxx> -S<B server> : test OK !
4. run VB6 apps with the TCP connection string : test OK !
What is problem in my A web server ?
View 28 Replies
View Related
Mar 10, 2008
TITLE: Connect to Server
------------------------------
Cannot connect to WINSP3UESQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
can anyone kindly assist me?
View 1 Replies
View Related
Jan 9, 2008
This is the error: "Unable to open database. Data source name not found and no default driver specified". But there's a catch! Read on...
Our application was written using MFC (ODBC CDatabase class) and the Open function takes a connection string like this:
"Driver={SQL Native Client};Server=%s\INSTANCE;Database=dbname;Uid=loginname;Pwd=password"
The %s in the connection string is either set to "localhost" or in the case of a client/server setup, the user chooses a host from a list the first time they run the application, so it becomes "SOMECOMPUTERNAME".
Here's the catch: the application can connect to the remote server if SQL Server is installed on the client machine. When we install our application on a clean, freshly installed XP machine, we get the error.
However the ODBC Data Source Administration tool recognizes SQL Server and I can successfully create a DSN to our remote SQL Server using it.
What does installing SQL Server do to allow the connection string to work and what do I need to do to NOT install SQL Server on our client machines?
View 7 Replies
View Related
Apr 18, 2007
I have a SQL Server 2005 instance which resides on a dedicated server hosted by a third party. I am able to connect to this server through my local SQL Management Studio, however, my local ASP.NET 2.0 web application cannot connect. I get the error below. The connection string I use is formatted as...
Connection String:
Server=thesever;uid=myuserid;pwd=mypassword;database=mydatabase
Error:
Failed to connect to database: 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)
The hosting providr claims that the SQL Server configuration settings are as they should be as fars as TCP/IP and Named Pipes are concerned. Does anyone know what might be going on?
View 1 Replies
View Related
May 30, 2007
Hello
I am able to connect to the server and most of the time I can't connect.
It is important to be able to connect so I can manage my mdf - database.
To test ... I disable the firework but I still can't connect 90% of the time.
Thank you in advance.
~ Peaches ~
View 3 Replies
View Related
Sep 25, 2007
Server Error in '/Dive' Application.
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)
this is the error message I found when I run my asp.net application and the connection string as follows:
<add key="ConnectionInfo" value="Server=(local);Database=Dive;Trusted_Connection=yes;" />
can someone tell me how to connect and how to specify username and password in Visual Web Developer 2005 Express Edition..........
I'm a little bit new on VWD 2005 I need an assistance on it.
View 4 Replies
View Related
Jun 19, 2008
Hi all,
I am using SQL 2005 Express to store my databae on a remote server, I already set remote connections to Local and remote connections (Use TCP/IP only) and also allow it to listen all the ports. Also I disabled my firewall. Then In my web.config file I add the conncting string like below
<add name="ConnString" connectionString=" Server=123.xxx.xxx.xxxDEV11SQLEXPRESS; Database=xxx; User ID=tester; Password=test; Trusted_Connection=False" providerName="System.Data.SqlClient"/>
Then I got the following error
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Any ideas? Thanks in advance.
View 5 Replies
View Related
Jul 22, 2005
My VS 2005 website project was connecting to a remote SQL Server. But after I move the database to the second SQL Server, I got the following error message from running my website project:
Named Pipes Provider: Logon failure: unknown user name or bad password.
I do everything same like what I did in the first SQL server:
Using “SQL Server and Windows� authentication and “System account�;
Create a domain account IIS_WPG;
Grant this IIS_WPG as db_owner for the database;
In web.config, add the name and password to the end of connectionstring;
Make sure the SQL Server has “Named Pipes� and “TCP/IP� protocols.
I have no idea what I can do else, anybody has suggestions?
View 3 Replies
View Related
