A connection was successfully established with the server, but then an error occurred during the login process. | SansSQL

Friday, August 22, 2014

A connection was successfully established with the server, but then an error occurred during the login process.

Recently I came across an issue when connecting to SQL Server instance using SQL Authentication.
The error says,
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)


To fix the issue, Disable "Shared Memory" protocol in the SQL Server Configuration Manager.


To find the status of SQL Server Protocols using T-SQL, refer to the below link
http://www.sanssql.com/2011/04/t-sql-query-to-find-sql-server.html

5 comments:

Austin said...

This didn't work

Austin said...

This didn't work

wael abed said...

Hi All,


I faced the same issue once and what I did was

1. I stopped all other services (Analysis, integration and reporting services) and restarted the MSSQLSERVER service.
2. Then I was able to connect to database engine using SSMS.
3. Properties > Connection > Changed the value into 0 (Unlimited).

Anonymous said...

In my case I changed the connection mode from windows authentication mode to SQL Sever and Windows Authentication mode.Then it works!

Darren Demers said...

Recently I came across an issue when connecting to SQL Server instance using SQL Authentication.
how to use cricut heat press for shirts
best cricut to make stickers
cricut sunflower
cricut gifts for dad
different types of vinyl for cricut
flower images for cricut
design for cricut
cricut award ideas

Post a Comment

Ads