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
