Recently our SQL server had many occurrences, where applications web and windows based trying to access received following errors
- A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 – The specified network name is no longer available.)
- Exception type: SqlException Exception message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The specified network name is no longer available.)
This is running on a VM and the Datacenter guys have ruled out any issues related to Network or VM Level. I also checked Event Viewer logs no luck there. So wanted to check if this is something related to the SQL Server itself.