Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-07 : 14:05:09
|
| Deepam writes "Server Error in '/ABC' Application.----------------------------------------------------------------I am using SQL Server 2000 as the server and client on 2 different machines. The connectionstring used is - "Data Source=,1433;Network Library=DBNETLIB;Initial Catalog=LMS;;Initial Catalog=LMS;User ID=sa;Password=;";The TCP and Pipes are both enabled on the machines as well as the Remote Connection setting is also enabled. Even then, 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) I have tried using the following formats for connectionstring as well - "Data Source=HDDLRCC22A2047;Initial Catalog=LMS;;Initial Catalog=LMS;User ID=sa;Password=;";where HDDLRCC22A2047 is the server name. But nothing seems to work.Please Help !" |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2006-08-07 : 15:05:04
|
| If all you are looking to do is connect just use the following format.If my information was the followingServerName = "TEST"SqlInstance = "MyTestSQL2000" //In most cases if there are not multiple instances installed just use the server name.UserID = "TESTUSER"Password = "TESTPASSWORD"DataBaseName = "TESTDB""Server=TEST\MyTestSQL200;User ID=TESTUSER;password=TESTPASSWORD;database=TESTDB"That should be all you need to do, but keep in mind like I said if you do not have multiple instances running then just use"Server=TEST;User ID=TESTUSER;password=TESTPASSWORD;database=TESTDB"Hope This helps. |
 |
|
|
|
|
|
Remote database connection error in SQL Server 2000