Tuesday, 25 October 2011

Error "A connection was successfully established with the server, but then an error occurred during the pre-login handshake" occurs when connecting to remote SQL Server databases on SQL Server 2005 or 2008

Hi All,
Today I encountered the below error when I tried to log on to SQL management studio database engine.

"Error "A connection was successfully established with the server, but then an error occurred during the pre-login handshake" occurs when connecting to remote SQL Server databases on SQL Server 2005 or 2008"


This issue was easily resolved when I enabled the Named Pipe in the SQL configuration manager and then restarted the SQL services


No comments:

Post a Comment