When I am trying to login into my local database server using SQL server management studio, I am getting an error, as shown below
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
How can I resolve this error? Thanks
Looks like your SQL Server services might not be running, so you need to manually start SQL Server services.
If you are on Windows 10, you can open Configuration manager by
Control Panel -> Administrative tools -> Open Computer Management ->Services and Application -> SQl server configuration manager, below is the screenshot
Simply start "SQL Server" services, if it is stopped and then re-try.
If the above solution doesn't work, try below steps:
You may also like to check:
Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly