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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-03-20 : 18:32:20
|
| Hi experts,My instance which is in sql 2000 is not running when i saw it in the services the status of it is starting but not getting started what i need to do now.i rebooted the box twice still its in the same state then i disabled the sql server and rebooted now what i need to do if i got the same problem again.Thank you in Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-03-21 : 09:05:08
|
| Sorry for the late reply Kizer,The application team called up and were asking that they were facing an issue with the server as they are not able to connect, as soon as i got the information i logged into the box and saw that in the services.msc I found that the sql services were in staring mode only i tried to stop but was failed to do, i rebooted the server but still the same it shows in the services in starting mode so i disabled the sql services and sql agent and rebooted then after getting back i changed it to manual and started the services then it cam up, but i couldn’t find what was the reason behind the services behaving like that.when i tried to connect to one single database i got this error message..'c:\program%20files\microsoft%20sql%20server/80/tools/binn/resources\1033/sqlmmc.rll/tabs.html'please let me know if i need to upgrade any thing in the server. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Instance is not running