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 |
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-11-07 : 08:04:28
|
Experts... im completely stuck. My laptop was stolen, my replacement arrives with vista on it. Get my SQL Stuff on it and when I try executing a select statement on one of the sql servers I get the error; An error occurred while executing batch. Error message is: Internal connection fatal error. and it simply disconnects. I cant run any queries! Please help."Impossible is Nothing" |
|
Kristen
Test
22859 Posts |
Posted - 2007-11-07 : 08:16:18
|
Firewall thingie? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-07 : 08:43:46
|
is tcp enabled?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-11-07 : 10:44:40
|
I can successfully execute queries on the local machine. Now I use SQL Management Studio to connect to my other sql servers. One is 2005 and the other is 2000.I cannot execute queries on either of these. This is even if I connect as "sa" in management studio, I often get the error "An error occurred while executing batch. Error message is: Non-negative number required.Parameter name: count" the query stops with say a hundred or so results and also I am then disconnected from the server.Im totally lost on this one. I am so far behind "Impossible is Nothing" |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-07 : 10:55:02
|
Sounds like firewall is preventing inbound traffic from the SQL boxCan you Ping your laptop from the SQL Box? |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-11-07 : 11:00:33
|
lol here is what happens; think I have a problem or two... "Impossible is Nothing" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-07 : 11:04:48
|
uninstall redgate stuff and restart your computer.if that doesn't help you'll have to reinstall management studio_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|