October 6, 2007 at 6:42 am
Hai,
I'm using windows XP SP2 and I have installed SQL Server 2005 Standard Edition. I usually connect my SQL Server 2005 using windows authentication mode and server name as default. I have a only one server to which 4 client machines are connected. When I'm connecting to my default server domain I get this message and I am unable to enter into SSMS
"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.) (Microsoft SQL Server, Error: 233)"
October 6, 2007 at 6:59 am
This could be any of the following
1. The required network protocols are not enabled..
2. Remote Connections disabled
3. Windows firewall may be blocking the connection...
--Ramesh
October 7, 2007 at 8:47 pm
Hi,
Check the below link and rectify your problem.
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
Regards..Vidhya Sagar
SQL-Articles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply