Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BrianBurgit
Starting Member
12 Posts |
 Posted - 2010-02-25 : 14:35:14
|
| We have a SQL instance at a remote hosted server and have some applications that run at our location here that access data in Tables at the remote instance. Today we've been having lots of connection problems when trying to access the remote instance. Note that many times the connection works fine. One of the error messages says [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Invalid connection string attributeNo changes have been made to anything related to the applications or the sql instance. In addition, I was importing a Table from the remore instance to my local SQL instance and it errored out after copying about 20,000 rows, saying communications error.I'm thinking everything is pointing to a problem with internet connectivity somewhere along the way, though all service provides told me everything is running fine.. Does anyone else think differently, could there be something wrong with the SQL instance itself? Anything I should look into deeper?Thanks,Brian |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-02-25 : 15:37:23
|
| Start with this: Can you PING the server or do you have the same intermittancy? If pinging has the same issue, then you have a simple connectivity problem outside of anything SQL related.=======================================Few things are harder to put up with than the annoyance of a good example. (Mark Twain) |
 |
|
|
|
|
|
Intermittent connection problems