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 |
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
 Posted - 2007-07-04 : 05:40:24
|
| Hi All,I have one script to be execute on two diff DBs. The only diff between these scripts are: Use <DB Name>. Rest all script are same. When I execute the script on 2nd DB i get the following error. Can anybody tell me, what the err is?Err:[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).Server: Msg 11, Level 16, State 1, Line 0General network error. Check your network documentation.ODBC: Msg 0, Level 16, State 1Communication link failureConnection Brokenthanks in advance,Mahesh |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 17:07:09
|
| How did you run the script? From client machine? How does client connect to sql server? Can you ping sql server? |
 |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-07-05 : 03:57:58
|
| rmiao, thx for replying. Actually one of the user havn't rights for execute scripts. I gave the premission to that user to execute scripts and prob get solved.But still i m confused, why such msg was displayed?Can anybody tell me?thanks in advance,Mahesh |
|
|
|
|
|
|
Connection Broken