Cannot connect to : 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) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476 —————————— BUTTONS: OK ——————————
1- Open SQL SERVER configuration MANAGER
2- SQL SERVER services
3- SQL SERVER (MSSQLSERVER )
4- CHANGE (Log ON AS)
5- SELECT LOCALSYSTEM
2 thoughts on “Error : FIXED ! . A connection was successfully established with the server, but then an error occurred during the pre-login handshake”
This worked!!! After hours of searching and trying to solve the problem. Thank you!
Hi all, This certainly helped me out, the LOCALSYSTEM user did not have the rights to apply the necessary certificates, I changed it to a network service account that had rights… problem solved. But it did take me a longtime to find it.