Problem with SqlServer 2005 when opening connections
Posted
by Jose Obregon
on Stack Overflow
See other posts from Stack Overflow
or by Jose Obregon
Published on 2010-03-19T18:39:12Z
Indexed on
2010/03/19
19:01 UTC
Read the original article
Hit count: 400
sql-server-2005
I have a Winforms application and I use EntLib to connect to a SQL Server 2005 DB. The application is working ok, but sometimes, and lately more often, we have started receiving this error from the db when opening the connection:
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)
The problem is intermittent. The user works well for a couple of hours and then suddenly the exception is thrown. Sometimes it happens when we run a small process that loads a file and then inserts the data to the db.
© Stack Overflow or respective owner