June 20, 2007 at 7:54 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 7:19 am
The SQL Server services are always running. If they stop their is a problem. Check both the sql server logs, and the agent logs. Also the NT logs. I would guess security is not configured right on the service that stops. It may not be automaticaly stopping but terminating abnormaly. Check service account and password.
June 21, 2007 at 11:58 pm
yes might be a permission issue. Check for permissions in registry, default installation pths, other installation paths and sql file paths.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 22, 2007 at 8:45 am
Thanks everyone for suggestion...here is what had happend..
I did update/checked security.etc..but din't help...
I have 2 instance of sql server running(2000 and 2005). Accidently while making some changes i had defined 1433 as default port for both server. I then removed this 1433 from the sql server 2005(which was giving me problem). It now works....
Thanks again for inputs and sorry for delay in sharing the solution...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply