However this is easy to fix, you just need to change the server name to correspond to the IP address of the server:Īfter this you need to restart the SQL Server’s instance and you are done. (provider: TCP Provider, error: 0 The specified network name is no longer available.) (Microsoft SQL Server, Error: 64) sql error-message. This can happen for example when your production environment is isolated from intranet and servers do not have fully qualified domain names. (provider: TCP Provider, error: 0 - The remote computer. This is caused by the Management Studio attempting to connect to the SQL Server by the server name reported by the server. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. The application calls a stored procedures to. When you dismiss the error it just keeps popping up time to time but otherwise everything seems to work. We have an application that access the database Sql server enterprise edition. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)

When you try to connect to Microsoft’s SQL Server using IP address with SQL Management studio you get this error:Ī transport-level error has occurred when receiving results from the server.

This problem has been bugging us for a long time.