Why am I getting this error "Internal connection fatal error" in only one of my stored procedures?

Question

This issue is similiar to here.

http://stackoverflow.com/questions/1155263/what-causes-internal-connection-fatal-errors

Except it's only happening on one stored procedure and is happening all of the time and is only happening when I access this stored procedure from my website.

I've even ran the stored procedure in SQL Server and it seems to execute fine.

What could possibly be the error?

Answer 1

As the message say, the problem is on connection to SQL.

Because its happends only to one procedure then my quest is that you have left some open connection to database just before try to call this store procedure.

You can check the connection by turn on Perfmon and see the connection pool. If its growing over time then you left open connections.

Also check if your network is stable, you are over Lan, Wan, web, local or remote ? In the connection string what do you use of this: 127.0.0.1 / localhost / or the real ip address ?.