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

Share this article :


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


• 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

Find Last Database Backup & Log Backup for MSSQL Server
Move SQL Server tempdb to Another Location
Determine MSSQL Server Collation
Login failed for user. (Microsoft SQL Server, Error: 18456)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM