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 |
Sarina
Starting Member
2 Posts |
Posted - 2004-07-06 : 22:34:03
|
Hi people,I am new to this forum and hope someone help me with this issue.The problem SQLSERVERService and SQLAGENT Service are not starting Manually. But when i restart the server it works fine.Error: The Service did not respond to the start or control request in a timely fashionError: Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect. SQL SERVER 2000 Windows 2000 serverLog on : Domain Account( has admin privleges to the local machine)I have checked few KB articles and everything looks fine.Could anyone help me with this, thanks.SM |
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-06 : 23:24:56
|
They aren't starting manually??? Why were you trying to start them manually in the first place? This can be a fun one to troubleshoot.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
Sarina
Starting Member
2 Posts |
Posted - 2004-07-07 : 01:56:54
|
hi,It assigned to autostart. I cant able to Stop and Start using EM!Does it make senseSM |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-07-23 : 06:14:26
|
But can you change the account that starts the agents? |
|
|
Caz
Starting Member
3 Posts |
Posted - 2004-07-23 : 08:18:07
|
Things I might check:-What you are logged on as. Looking at whether you have the rights to start the services. Are you stopping/starting the services from Enterprise Manager. Is the server registered here with an ID that has the appropriate access level, again looking at the right to start the services. I have noticed on a server I look after that the services admin account locks out as well periodically so I'd look at this.CazRegards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-23 : 12:36:25
|
What happens when you try to stop and start the services by logging into the database services and pulling up the services applet from admin tools which is in control panel?Tara |
|
|
|
|
|