Error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
Initially we are not able to connect the SQL server dnkgeitgsqlp002 with below error .
Error: connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The wait operation timed out.) (.Net SqlClient Data Provider)
As per suggestion by MS we need to enable the named pipes protocol on this server, post enable the named pipes normally we need to restart the SQL services on server .
sc queryex MSSQLSERVER
taskkill /f /pid [PID]
We did same thing post restart the services not come to online, services in stopping stage we have kill the process by below command .
- Click the Start menu
- Click Run or in the search bar type services.msc
- Press Enter
- Look for the service and check the Properties and identify its service name
- Once found, open a command prompt. Type sc queryex [servicename].
- Press Enter
- Identify the PID
- In the same command prompt type taskkill /pid [pid number] /f
- Press Enter
SQL DREAMS 