SQL Connection problem in Windows Service asp.net c#
-
Hello Sir/Mam I'm trying connect sql server 2000 in windows service with other system on same network. there are 4 system connected without any problem. But on other 4 system, it is giving error on connection open while starting windows service. The error is: "the service on local computer started and then stopped some services stop automatically" etc. Same Connection string working in web service without any error. But giving problem in Window Service. Is there any Configuration setting of that server or sql server 2000. Any help will be highly appreciated.........
-
Hello Sir/Mam I'm trying connect sql server 2000 in windows service with other system on same network. there are 4 system connected without any problem. But on other 4 system, it is giving error on connection open while starting windows service. The error is: "the service on local computer started and then stopped some services stop automatically" etc. Same Connection string working in web service without any error. But giving problem in Window Service. Is there any Configuration setting of that server or sql server 2000. Any help will be highly appreciated.........
You've asked this in at least one other forum. Please, just use one forum per question.
*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington
"Mind bleach! Send me mind bleach!" - Nagy Vilmos
CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier
-
Hello Sir/Mam I'm trying connect sql server 2000 in windows service with other system on same network. there are 4 system connected without any problem. But on other 4 system, it is giving error on connection open while starting windows service. The error is: "the service on local computer started and then stopped some services stop automatically" etc. Same Connection string working in web service without any error. But giving problem in Window Service. Is there any Configuration setting of that server or sql server 2000. Any help will be highly appreciated.........
can you use connection pool size 1 to 5 etc in your connection string