Forum Discussion
SQL 2008 error
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 error has started occurring ...
Hello,
This means that SQL Server is not accepting incoming connections .
Can you connect locally from the SQL machine ?
and I see you cannot connect from remote computers. test if TCP Port 1433 is open
you can either try with telnet
TELNET Servername 1433
Or Powershell
https://www.sqlshack.com/powershell-sql-server-validation-utility-dbachecks/
also make sure that the windows firewall on the server is allowing TCP 1433
Also, check the CPU usage on the server, sometimes when server is extremely busy it stops accepting incoming connections
This means that SQL Server is not accepting incoming connections .
Can you connect locally from the SQL machine ?
and I see you cannot connect from remote computers. test if TCP Port 1433 is open
you can either try with telnet
TELNET Servername 1433
Or Powershell
https://www.sqlshack.com/powershell-sql-server-validation-utility-dbachecks/
also make sure that the windows firewall on the server is allowing TCP 1433
Also, check the CPU usage on the server, sometimes when server is extremely busy it stops accepting incoming connections
Thanks for the reply.
Can you connect locally from the SQL machine ? yes
This issue is coming in all clients using sql-2008 versions, 3-4 PC are working but rest not.however I will get 1433 checked.
regards,
kamal
