February 4, 2014 at 4:07 pm
Hi, I am not very professional in sql server. I restored msdb from another server, but I did not pay attention because I was loggin with another sql server user. now my sa user is not able to login. I am just able to login with sql user which I restored my msdb database , and windows authentication user. When I want to log in with sa user I get this 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)
How can I fix this without reinstalling sqlserver? I really appreciate your response.
Thanks, MP
February 5, 2014 at 5:37 am
Read this link http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0a58d127-f532-44f1-8507-f9131228b5c1/connection-error-provider-shared-memory-provider-error-0-no-process-is-on-the-other-end-of?forum=sqldatabaseengine and check/try the different options mentioned here. Possible options are "check default database", "check protocol", "start SQL Agent" and many others....
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply