Question Locked

SQL server error

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I connect to the SQL 2008 server via Remote desktop successfully. I get this error when tring to access the database via SQL management studio. Error message: a connection was successfully established with the server, but then an error occured during the process (provider: shared memory provider error: 0 - no process is on the other end of the pipe. sql server error 233.

4 replies

by mnghishekwa

Thanks for your efforts, but I managed. It looks as if an update patch re-configured the security settings on my database. I restarted all the SQL services and logged into SQL with windows authentication. After inspecting my user account I noticed that I had no access to the db. Gave myself log in rights and 123, it works.

Thanks again

by shellbot

it all working and thanks for updating on your status.

This discussion is closed to new replies.