August 27, 2010 at 4:01 am
Hi all, I am using sql server 2005 and trying to login with sql server authentication( user sa account) but an error message occurred:
TITLE: Connect to Server
------------------------------
Cannot connect to ITPC.
------------------------------
ADDITIONAL INFORMATION:
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)
How should i do?
🙁
August 27, 2010 at 7:07 am
Check you have the "Shared Memory" protocol enabled for that instance. You can check this by opening SQL Server Config Manager -> SQL Native Client Config -> Client Protocals. May require a restart of the service.
August 27, 2010 at 9:46 pm
Yes I checked already, "Shared Memory" Protocol is enabled, but it is still the same problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply