Sunday, February 12, 2012

Can't connect to default database

I installed SQL Server 2005 standard edition. When I am trying to connect
(via SQL Server Management Studio)to the default local dB by using SA. I get
the following error:
Cannot connect to <server name in here>
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.
I have Shared memory enabled as well as TCP/IP.
Any ideas what's wrong?
Thanks
WendyRun the Surface Area Configuration tool to make sure you
have enabled remote connections and with the protocols you
need.
-Sue
On Mon, 13 Mar 2006 13:26:27 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:

>I installed SQL Server 2005 standard edition. When I am trying to connect
>(via SQL Server Management Studio)to the default local dB by using SA. I ge
t
>the following error:
>Cannot connect to <server name in here>
>A connection was successfully established with the server, but then an erro
r
>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
.
>I have Shared memory enabled as well as TCP/IP.
>Any ideas what's wrong?
>Thanks
>Wendy

No comments:

Post a Comment