Friday, February 10, 2012

Can NOT login in to SQL2005 with SQl Server Mangement Tool

I get the following error when trying to connect to my server that is on my local maching:

provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233

It happened after I changed the allowed remote connections to 1. It appears tha I can not log into the server at all. Any way to fix this besides reinstalling SQL Server?

Thanks, Doug

You do not need to re-install. Start here for a complete tutorial:

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

And then check here as well:

http://support.microsoft.com/default.aspx/kb/265808/

If you've done all that, make sure your firewall is set up, as referenced by the "see also" links.

Buck Woody

No comments:

Post a Comment