MSSQL1 keeps resetting?

Shannara

Shannara

Perch
My MSSQL1 connection keeps getting forcibly disconnected on a daily basis (it seems). Is MSSQL1 server having network problems?
 
Shannara said:
My MSSQL1 connection keeps getting forcibly disconnected on a daily basis (it seems). Is MSSQL1 server having network problems?
Click to expand...

Hello,

What exactly makes you think that?
Do you observe that on your site? Or on your connections via enterprise manager?
 
Thanks for the reply :) I tracked it down to a forced timeout with SQL server. I ended up running my own SQL Server install on a box, and referenced that.

Thanks again :)
 
Shannara said:
Thanks for the reply :) I tracked it down to a forced timeout with SQL server. I ended up running my own SQL Server install on a box, and referenced that.

Thanks again :)
Click to expand...

What do you mean a forced timeout, like after being idle?
 
I think that may be the case. For instance, I kept getting that forceful disconnect error in my VB app. Even though I had a dummy select statement running every few minutes.

But for some reason, even if I had that dummy statement run every minute, I get the same error after awhile.

What I ended up doing, was running SQL on a dedicated, had the VB app run against that, and use that dummy statement, and everything is peachy now :)

This was actually needed as two-fold. Since I share the same SQL server for some forums and the like, I didn't want to fill up my quota here.
 
You must log in or register to reply here.
Back
Top