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.