Problem with SqlServer 2005 when openning 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 18:41 UTC
Read the original article Hit count: 381

Filed under:

sqlserver-2005

I have a Winforms application and I use EntLib to connect to a SQL Server 2005 DB. The application is working ok, but somethings, and lately more often, we have started receiving this error from the db when openning 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 nice 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.

Please if anybody has any thought on this help me

Related posts about sqlserver-2005

how to save excel file in sqlserver 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a table in which there are two columns : 1. import type, 2. Excel import template. The second column - "Excel import template" should store the whole excel file. How would I save excel file in databse...can I use binary datatype column, convert excel file to bytes and save the same … >>> More
Problem with SqlServer 2005 when openning connections

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Winforms application and I use EntLib to connect to a SQL Server 2005 DB. The application is working ok, but somethings, and lately more often, we have started receiving this error from the db when openning the connection: A connection was successfully established with the server, but then… >>> More
Alter SQLServer 2005 Most Recent List

as seen on Code Project - Search for 'Code Project'
Demonstrates how to Adjust the SQL2005 MRU using Reflection and the SQL Assemblies >>> More
How do I configure the number of worker threads used by SqlServer 2005 Agent

as seen on Server Fault - Search for 'Server Fault'
How can I increase the limit of worker threads from the default 10 for SQL Server 2005 SqlAgent? I have 9 jobs that run almost continuously and that leaves only one available thread for the rest of the scheduled jobs. Oftentimes, when no thread is available, I will see the jobs in "Waiting for worker… >>> More
Problem with SqlServer 2005 when opening connections

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More

Developer IT