May 23, 2011 at 6:52 am
I want to restore master database in SQL server 2008. I have changed the startup parameter to logon as s single user mode. But while connecting through SSMS I am getting the below error message
"A connection was successfully established with the server, but then an error occured 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)"
Could you plese tell me the workaround for this?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
May 23, 2011 at 7:05 am
Sumanta Roy (5/23/2011)
I want to restore master database in SQL server 2008. I have changed the startup parameter to logon as s single user mode. But while connecting through SSMS I am getting the below error message"A connection was successfully established with the server, but then an error occured 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)"
Could you plese tell me the workaround for this?
Try via command line instead of SSMS.
Also check the protocols too.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 23, 2011 at 7:13 am
Getting the same error when connecting through cmd prompt. This may be due to some other automatic connection is getting established before I connect to the server.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply