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!