SQL: No process is on the other end of the pipe



Share this article :

Symptom

You want to connect to the SQL database but ended with below error,

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.) (Microsoft SQL Server, Error: 233)

SQL - No process is on the other end of the pipe

Solution

• Ensure both SQL Server and SQL Server Agent are running. You can determine from the Windows services or SQL Server Configuration Manager.

• Ensure the TCP/IP protocol is enable. You can enable the protocol via SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER.

• Switch the authentication, try to login with Windows Authentication / SQL Server Authentication. Use sa username and password if you have the access.

• Refer to MSSQL: Cannot open user default database. Login failed.

Related posts

Check SQL Server Database Status
Check & Change MSSQL Server Compatibility Level
Find Last Database Backup & Log Backup for MSSQL Server
How to Activate xp_cmdshell Server Configuration Option
© 2017 ITsiti. All Rights Reserved
Powered by KEEM