Symptom: (Provider: Shared Memory Provider, error:0 – There is no process on the other end of the pipe.
Error screenshot:
Unable to connect to DESKTOP SQLEXPRESS
Workaround: Windows authentication is required to connect to the database.
Operation steps:
- Right-click SQLServer 2012 server → Properties → Security
Close SQL Server, open it again,
Login error:
Connection to the server was successfully established, but error 233 occurred during login
At this time, still can not log in, do not worry, this is because the corresponding system service did not restart.
- Restart related SQL Server services
Press the combination key: Win +R on the keyboard to pop up the [Run] dialog box and enter: services.msc
Find the two services shown below:
Restart or set the corresponding service to automatic start.
- Log in to the SQL Server2012 user name (sa) again. The login succeeds.
The diagram below:
- That’s it.