June 20, 2007 at 7:53 am
I have SQL Server 2005 running on Win 2003. Whenever I use the SQL Service manager to start the service it starts then automatically stops.
When I try to do the same thing through the control panel services manager I get a message saying that the service started then stopped and that this happens for some services when they have no work to do.
Any ideas?
June 20, 2007 at 8:00 am
Do you have service packs installed. If not trying going for SP2 and start your service and check if its ok.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 21, 2007 at 10:18 am
Try using local system and see if it starts. Most of the time, the authentication or level of access for the account you are using is incorrect.
HTH,
Kelly
June 26, 2007 at 1:21 am
BTW, are you on a clustered environment?
Pankaj Khanna
Database Administrator - SQL Server 2000
Keep hope to keep you intact...
June 27, 2007 at 6:19 am
anything in the errorlog?
---------------------------------------------------------------------
July 11, 2007 at 9:29 am
Any check on the antivirus which could block the service to run?Did you disallowed your antivirus to scan the data files by the way?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply