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 |
|
Kirun
Yak Posting Veteran
60 Posts |
 Posted - 2007-10-11 : 08:03:10
|
| I have SQL 05 and SQL 200o on same server . SQL 05 version is a named inatnce. But when i try to connect it from my computer first it doest show the name instance in the list and when i manulay write its name i got this error. "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)"I went to check that remote connectiona nd SQL browsing is on or not but both were on . any ideas why this is happening and why the name is not coming in list of Server.Thanks |
|
|
crosan
Starting Member
13 Posts |
Posted - 2007-10-11 : 09:19:11
|
| If you're sure that it's set to allow remote connections, I'd check to make sure that you are using either named pipes or preferably tcp/ip in both the client connection and server configuration. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-11 : 23:26:26
|
| You are using named pipes, ensure it's enabled on the server. |
|
|
|
|
|
|
error connecting to an instance of SQL 05 remotely