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.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 SQL Query failed

Author  Topic 

aktaton
Starting Member

10 Posts

Posted - 2006-09-28 : 09:56:43
Greetings to all,

while running distributed querries, SQL server took a very long time and failed. We are receiving the following error:
Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken

Any help is greatly appreciated. Thank you in advance.

Kristen
Test

22859 Posts

Posted - 2006-09-28 : 11:18:24
Generally means that the connectivity to your server has broken, or the connectivity has changed (could be at either end) so the server could not be found, or possibly its security/permissions have changed and are preventing you getting access.

If this is the first time you've tried to connect from that machine, and you have connected from other machines, then check the connection settings you are using - they are almost certainly wrong in some regard.

Kristen
Go to Top of Page

aktaton
Starting Member

10 Posts

Posted - 2006-09-28 : 12:45:23
Thank you Kristen,
We figured that it was the log file that was causing the problem. We moved the log file to another partition and it is fixed. Thank you.
Go to Top of Page
   

- Advertisement -