question

inder avatar image
inder asked

TCP Provider Specified Network Name No Longer Available

I have a web application that uses SQL Server 2008 database.At times I get the error message "TCP Provider Specified Network Name No Longer Available".No doubt that it happens during peak hours but I am unable to understand why not time out or execution delay.I am opening a connection and using that connection to resturn a number of datasets. I have tried TCP chimney registry setting but no success. I have check any cable/network related issue and there is no connection broken between database server and application server
sql-server-2008
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
That sure sounds like something is up within your network, not SQL Server. That error is specific that TCP names are not resolving. I'd focus my efforts there, not on SQL Server.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

inder avatar image inder commented ·
Thanks. I am going to change all networking stuff and will check if it goes well or not.
0 Likes 0 ·
inder avatar image inder commented ·
Thanks Grant. We updated the LB and get rid of the problem
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.