none
SQL Server service will not restart after failed windows updates

    Pregunta

  • I attempted windows update OS Windows Server 2008 64 and restarted the machine.
    Now the Sql Server is not starting.VIA is disabled.

    Windows Updates KB948109,KB951978, and KB950050 all failed

     

    SQL Server error log follows

     

    2008-09-14 21:34:43.62 Server Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

    Feb 10 2007 00:59:02

    Copyright (c) 1988-2005 Microsoft Corporation

    Standard Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)

    2008-09-14 21:34:43.62 Server (c) 2005 Microsoft Corporation.

    2008-09-14 21:34:43.62 Server All rights reserved.

    2008-09-14 21:34:43.62 Server Server process ID is 3824.

    2008-09-14 21:34:43.62 Server Authentication mode is MIXED.

    2008-09-14 21:34:43.62 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

    2008-09-14 21:34:43.62 Server This instance of SQL Server last reported using a process ID of 1940 at 9/13/2008 7:06:51 PM (local) 9/13/2008 11:06:51 PM (UTC). This is an informational message only; no user action is required.

    2008-09-14 21:34:43.62 Server Error: 17053, Severity: 16, State: 1.

    2008-09-14 21:34:43.62 Server UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.

    2008-09-14 21:34:43.62 Server Registry startup parameters:

    2008-09-14 21:34:43.62 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

    2008-09-14 21:34:43.62 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

    2008-09-14 21:34:43.62 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf

    2008-09-14 21:34:43.62 Server Error: 17113, Severity: 16, State: 1.

    2008-09-14 21:34:43.62 Server Error 3(The system cannot find the path specified.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

    2008-09-14 21:34:43.62 Server Error: 17053, Severity: 16, State: 1.

    2008-09-14 21:34:43.62 Server UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.


    lunes, 15 de septiembre de 2008 2:35

Respuestas

  • Resolved By Microsoft. It appears that the user that is running the service pack must have full permision to the MSSQL folder by NAME not by group. Dont know why.

     

    martes, 16 de septiembre de 2008 20:18

Todas las respuestas

  • Mike,

    The error message indicates that startup parameter for the master database is incorrect and (or) permission missing for accessing the master database files. Please check the path where master.mdf and master.ldf resides and mention that path in the Sql Server startup parameter.
    Go to Sql Server configuration manager and click on the Sql Service properties and check for the startup parameters. It should be something like,

    -dC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA \mastlog.ldf


    Please note that the spacing should be proper in the above command and you should also have the semicolon placed properly. Also ensure that the Sql Service account has modify permissions to the folder where Sql Server database files reside.

    - Deepak
    lunes, 15 de septiembre de 2008 5:08
  • Resolved By Microsoft. It appears that the user that is running the service pack must have full permision to the MSSQL folder by NAME not by group. Dont know why.

     

    martes, 16 de septiembre de 2008 20:18
  •  MikeBr wrote:
    Resolved By Microsoft. It appears that the user that is running the service pack must have full permision to the MSSQL folder by NAME not by group. Dont know why.

     

    What does that mean?

     

    I put my identity in the folder security, both MSSQL and data, and re-ran the update.  The update failed and the service still won't start.

     

    What user?  I don't know what user is running the service pack installation!

    miércoles, 08 de octubre de 2008 15:55
  • This fixed it for me:

     

    1. Goto -> Administrative Tools
    2. Click on Services, then look for SQL Server (SqlExpress)
    3. Right click on the item, then select Properties
    4. Click on Log On tab, then tick on Local System Account

    Then I ran the SS2005 security update (whose repeated failure I believe started the problem), it finished successfully and I am able to access the database again.  I don't know if this requires the modification above in combination but note that I had the folder security change in place as well.

     

    This is an instance of Express Edition.

     

    miércoles, 08 de octubre de 2008 16:37
  • I ran the install of the latest security update using an administrator account. The install failed.

     

    In the case of my server, "resolved by Microsoft" means that the account that runs SQL Server must have admin privileges on the machine. We use a domain account to run our Sql svrs. I also find that the install of the security update fails consistently for the Sql Server database services component although the others succeed.  

     

    After the install of the security update failed for this component, I was not able to restart the sql server database service until I allowed the service account admin prives, then I could restart the service.

     

    This is NO  resolution to the problem. It's a temporary fix to get the databases up until Microsoft actually does resolve the problem.

    martes, 28 de octubre de 2008 14:31