Msg 64, Level 20, State 0, Line 0 SQL Server Error
I am running sproc on SQL Server 2005, which results in the following error:
Msg 64, Level 20, State 0, Line 0 A A transport error occurred while retrieving results from the server. (provider: TCP provider, error: 0 - The specified network name is no longer available.)
As soon as the error occurs, I will lose my connection to the server, but I can reconnect.
There is nothing in the event logs. The database is still up and running and works great on its website.
EDIT: This happens every time I run this sproc or is called by the application.
Any suggestions on what might be causing this error?
source to share
This happens when the database server is unavailable when opening a client connection.
Replay: If you have a query in SSMS, restart the SQL instance, run the query again to get this error.
Thoughts:
- Does the SQL instance restart?
- Is the DB closed automatically ? (like desktop editions, don't use them yourself though)
- Problems with your firewall?
source to share
Some thoughts:
This can be triggered when the connection pool is enabled, and for some reason one connection in the pool loses its connection to the DB (due to a network hang or any other reason).
Does this happen every time you call this sproc?
Is sproc trying to access the linked server?
source to share