Failed to connect to sql server problem - a strange one!

Full Error message is:

Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo)

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

When I consult the error log I see:

Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-01-30 04:53:14.93 Logon Error: 17809, Severity: 20, State: 3.

_

The log error message doesn't make any sense because there aren't 4 user connections.

After I received the error message, mgmt studio still lets me access the database make changes, but I cannot connect via my application. Any ideas? Thanks!

Hi,

are you using connection pooling ? Seems that your application does not release the connection after using them. You should consider your code regarding this. If you are not sure who is connected to your computer you should consider querying the procedure sp_who.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||It's a windows application that is connecting to this database and I'm not using connection pooling. Although I can get into the database and look around, I cannot query it. So, I can't run sp_who. Any other suggestions? Thanks for the reponse|||Lots similar issues are posted on the blog (http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx). Can you take a look at sql trace files and monitor SQL Server error logs? They might also help you to find the clues.|||

SSMS usually open two connection to the db. You can query your db using SSMS to see the connection state, by "select * from sys.dm_exec_connections".

|||I'll give her a try....|||When I searched with Google, I found the blog to which you refer. I wasn't able to figure anything out, but I may give it another shot. Thanks for the info.|||

i had same trouble, in my case this link gave solution. it is about certificates.

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

i hope this answer for you.