all groups > sql server connect > september 2006 >
You're in the

sql server connect

group:

Problem connecting to local server


Problem connecting to local server us10lh-google NO[at]SPAM yahoo.com
9/26/2006 2:39:30 PM
sql server connect: I've got SQL Server 2005 installed on my PC, set to mixed-mode
authentication. For months, I've been logging in to Management Studio
using the "sa" account. Recently, something changed and I can no longer
do that. I get the following 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)"

In my application, I _can_ connect to the databases using the sa
account.

Ideas as to what the problem might be? TIA.
Re: Problem connecting to local server Sue Hoegemeier
9/27/2006 7:18:04 AM
Use the SQL Server Configuration Manager and make sure
Shared Memory protocol is enabled on the server.
If that doesn't work, try restarting and check the SQL
Server log to see if there are any problems with the Shared
Memory protocol when you restarted.

-Sue

On 26 Sep 2006 14:39:30 -0700, us10lh-google@yahoo.com
[quoted text, click to view]
AddThis Social Bookmark Button