June 1, 2009 at 6:40 am
Hi,
I am trying to connect to SQL Server 2005 on the local system. It is able to connect but as soon as I try to do a new query, it gives the following error:
TITLE: Connect to Database Engine
------------------------------
Cannot connect to
------------------------------
ADDITIONAL INFORMATION:
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I checked, the following protocols are enabled:
Shared Memory
Named Pipes
TCP\IP
Do I need to change any other settings?
Any help will be greatly appreciated.
Thanks
Hema
June 1, 2009 at 6:58 am
I think the sql server services is not running.
Can you check if it is running or not?
June 1, 2009 at 8:25 am
Hello Hema,
Just to check, can you create one connection to the SQL Server Okay and then subsequent Connections fail with this error?
If so, I just wonder if the maximum number of concurrent connections is being exceeded?
Do you have any (useful) entries in the SQL Error Log around the time that you try to connect? The Error Log can be found (in a default installation) at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
Also, is there a Level and State reported with the Error Number 233?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
June 2, 2009 at 12:08 am
Thanks for the reply John.
It was an issue with the concurrent connections.
The person who owns the server had set the value to 1.
It has been reset to Zero using sp_configure.
Thanks a bunch!!!
Hema
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply