|
Home > Archive > MS SQL Server > July 2005 > SQL server not starting after installing SP4
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL server not starting after installing SP4
|
|
| Tom@hotmail 2005-07-22, 7:23 am |
| Today I installed SP4 on our production SQL server, but after the first
part of the installation SQL server refused to start and gave the
following errors in the eventlog
Event ID 7000
The MSSQL$PROD02 service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
EventID 7009
Timeout (30000 milliseconds) waiting for the MSSQL$PROD02 service to
connect.
Rebooting the server did not help. After some debugging I found the
server to be able to start after making the SQL-server service user an
administrator on the machine.
So the accute problem has been solved for now, but I was wondering why
the SQLServer service user had to be in the administrators group with
SP4, until SP3 running SQLserver as a normal user worked fine.
anybody who know about this issue, or hwo has experienced the same
problem ?
| |
| Paulo F 2005-07-22, 9:23 am |
| Hi,
try using FileMon from sysinternals, change back the user removing the
administrator permissions. Start the filemon and then start sql server.
You may then see where and what is having access denied, then you may fix it
at the NTFS level.
Just for curiosity please respond here the result. Tks.
"Tom@hotmail" wrote:
> Today I installed SP4 on our production SQL server, but after the first
> part of the installation SQL server refused to start and gave the
> following errors in the eventlog
>
> Event ID 7000
> The MSSQL$PROD02 service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
>
> EventID 7009
> Timeout (30000 milliseconds) waiting for the MSSQL$PROD02 service to
> connect.
>
> Rebooting the server did not help. After some debugging I found the
> server to be able to start after making the SQL-server service user an
> administrator on the machine.
>
> So the accute problem has been solved for now, but I was wondering why
> the SQLServer service user had to be in the administrators group with
> SP4, until SP3 running SQLserver as a normal user worked fine.
>
> anybody who know about this issue, or hwo has experienced the same
> problem ?
>
>
|
|
|
|
|