Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

We are in the process of moving to a new hosting provider and after setting up a very simple database in SQL Server 2005, I noticed that if I wait more than 10 seconds or so between running queries remotely using management studio, I get the following error:

A transport-level error has occurred when sending the request to the server. provider: TCP Provider, error: 0

We also get a similar error when running an SSIS package from our office to the hosted database.

The host has not been very helpful at all, so I'm trying to narrow down what the problem could possibly be. Any help would be greatly appreciated. Thanks!

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I would take a look at the firewalls between you and them. Most firewalls have an idle session timeout setting of some kind to keep idle sessions (connected but no data flowing) from consuming resources (RAM, CPU, session state table entries, etc). See if your host is aware of what this setting is on their firewall and see if it's an adjustable setting.

share|improve this answer
    
It was the firewall. After I finally convinced them that the problem was on their side, they found a sql session timeout setting in the firewall, which was set to 10 seconds. –  Adam Dec 3 '09 at 19:48
    
Glad you got it figured out. –  joeqwerty Dec 3 '09 at 20:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.