April 15, 2010 at 5:53 am
Hi,
I have set the sql server database service as Automatic and the Agent service as Manual. while restarting the windows server sql server database service has not started then i have started the sql server database services manually. Sql server database serivce is runing on the local system permission.
Can anyone share your knowledge or experience on this issue ?
Thanks in Advance.
April 15, 2010 at 6:12 am
it works fine. not sure why this issue is there at ur end :w00t:
April 15, 2010 at 6:21 am
Did you check the event log to see why it did not start? That is the first step to find out why a service did not start up.
-Roy
April 15, 2010 at 7:09 am
Roy Ernest (4/15/2010)
Did you check the event log to see why it did not start? That is the first step to find out why a service did not start up.
I found the following error messages in the event log
1) Timeout (30000 milliseconds) waiting for the SQL Server (MSSQLSERVER) service to connect.
2) "The SQL Server (MSSQLSERVER) service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion. "
Pls update your comments on that ...
April 15, 2010 at 7:14 am
Does this server have only SQL Server in it or are you using that same server for other purposes? When booting up, are there lots of things done on start up? Is it running anti virus at the time of start up? (Full scan)
-Roy
April 15, 2010 at 10:27 pm
Roy Ernest (4/15/2010)
Does this server have only SQL Server in it or are you using that same server for other purposes? When booting up, are there lots of things done on start up? Is it running anti virus at the time of start up? (Full scan)
This server is deticated for sql server alone.Yes anti virus is running on the server.if you think anti virus scan is the problem, how can i confirm this or avoid the problem from the virus scan ?
April 16, 2010 at 3:30 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply