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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-12-13 : 02:18:59
|
| hello,The sql server agent is not able to start on my server.and no users are able to connect to the datebase.there was some users conflict on our server and the network admin newly created all the user accounts yesterday night.and today mornin due to some problems we had to restar the server and afterwards the sql server is not starting .I have tried starting the services but it gives the following error: when I try to start the slqserserveragent it says:the dependency sercice or group failed to start.and when I try to start MASSQLSERVER service it says the service did not start due to a login failure.I am usin windows 2000 advanced server and sql server 2000.Please help.regardsharshal. |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-12-13 : 03:29:00
|
| I think that the problem is in the account the SQL service runs under. At the point of instalation, you decide under which account the service will be running (domain or local). The fact that all domain accounts were recreated is probably the cause of being not able to restart the service.Lookup BOL under "accounts" for further information. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-13 : 07:46:16
|
quote:
I think that the problem is in the account the SQL service runs under. At the point of instalation, you decide under which account the service will be running (domain or local). The fact that all domain accounts were recreated is probably the cause of being not able to restart the service.Lookup BOL under "accounts" for further information.
Great . it worked .I had to go to the services and change the log on properties for the sqlserver.and it worked .now the server is up.still we have a same server for production database and all sites are also residing on the same server.so today we are seperating the two servers we have got a brand new server for database.I hope I don't get these type of problems again.thanks for u'r help .regards,harshal. |
|
|
|
|
|
|
server down services not starting !!!!!!!!