Iniciar sesión con Microsoft
Iniciar sesión o crear una cuenta
Hola:
Seleccione una cuenta diferente.
Tiene varias cuentas
Elija la cuenta con la que desea iniciar sesión.
Inglés
Este artículo no está disponible en su idioma.

Symptoms

When you try to install a security update for Microsoft SQL Server 2005 Service Pack 2, Microsoft SQL Server 2005 is not successfully updated. This issue occurs because the rollback process for the security updates incorrectly removes the SQL Server 2005 service accounts from the respective local SQL Server service groups.

Cause

This issue occurs because the rollback process for security updates incorrectly removes the SQL Server 2005 service accounts from the respective local SQL Server service groups. The permissions are granted to local service groups and not to the service accounts. Therefore, the services cannot access the required resources, and the services cannot start.

Resolution

To resolve this issue, follow these steps:

  1. Identify the SQL Server 2005 service group that is located on your computer. To do this, follow these steps:

    1. Click Start, click
      Run, type compmgmt.msc, and then press ENTER.

    2. Expand Local Users and Groups, and then click Groups.

  2. The SQL Server 2005 service group starts with "SQLServer2005." Identify each group, and then double-click to determine the group membership. If the group membership is empty, go to step 3. If the group membership is not empty, check the next group.

  3. In the Services Microsoft Management Console (MMC) snap-in, determine the service account for the SQL Server 2005 services.

    To open the Services snap-in, click
    Start, click Run, type
    services.msc, and then press ENTER.

  4. The names of SQL Server services start with "SQL Server." For example, "SQL Server (MSSQLSERVER)" is a SQL Engine service for the default instance of SQL Server. To determine whether this service is from SQL Server 2005, follow these steps:

    1. Right-click the service, and then click Properties.

    2. Locate the program file of this service. This file is shown in the Path to executable area.

    3. Right-click the file name, the properties, and the version. The file version should begin with either "9.0" or "2005.90."

  5. In the Computer Management MMC snap-in, double-click the service group name that you located in step 2. Determine whether the service account entry is missing in the service group. If the service account entry is missing, click Add, type the service account name in the Enter the object name to selectdialog box, and then click OK.

    Note To open the Computer Management MMC snap-in, click
    Start, click Run, type
    compmgmt.msc, and then press ENTER.

  6. In the Services MMC snap-in, start the SQL Server services.

    Note To open the Services snap-in, click Start, click
    Run, type services.msc, and then press ENTER.

More Information

The Microsoft SQL Server 2005 Setup program creates a local Windows group for each service that you install. The created Windows group is called a "service group."

The SQL Server 2005 Setup program adds the service account for each service to its respective group. All the Windows NT permissions that are required by a specific SQL Server service are granted to each Windows group.

These groups simplify the permission-granting process that is required to run SQL Server services and other executables. These groups also help secure SQL Server files. The SQL Server services access the Windows resources and SQL Server resources through the service group membership.

The following services and service groups are created during the SQL Server 2005 setup process.

SQL Server service

Service group

SQL Server

Default instance: SQLServer2005MSSQLUser$ComputerName$MSSQLSERVER
Named instance: SQLServer2005MSSQLUser$ComputerName$InstanceName

SQL Server Agent

Default instance: SQLServer2005SQLAgentUser$ComputerName$MSSQLSERVER

Named instance: SQLServer2005SQLAgentUser$ComputerName$InstanceName

Analysis Services

Default instance: SQLServer2005MSOLAPUser$ComputerName$MSSQLSERVER

Named instance: SQLServer2005MSOLAPUser$ComputerName$InstanceName

Reporting Services

Default instance:

SQLServer2005ReportServerUser$ComputerName$MSSQLSERVER and SQLServer2005ReportingServicesWebServiceUser$ComputerName$MSSQLSERVER


Named instance:

SQLServer2005ReportServerUser$ComputerName$InstanceName and SQLServer2005ReportingServicesWebServiceUser$ComputerName$InstanceName

Notification Services

Default or named instance: SQLServer2005NotificationServicesUser$ComputerName

Integration Services

Default or named instance: SQLServer2005DTSUser$ComputerName

Full-Text Search

Default instance: SQLServer2005MSFTEUser$ComputerName$MSSQLSERVER

Named instance: SQLServer2005MSFTEUser$ComputerName$InstanceName

SQL Server Browser

Default or named instance: SQLServer2005SQLBrowserUser$ComputerName

SQL Server Active Directory Helper

Default or named instance: SQLServer2005MSSQLServerADHelperUser$ComputerName

For more information about how to set up Windows service accounts, visit the following Microsoft Web site:

http://msdn.microsoft.com/en-us/library/ms143504(SQL.90).aspx

¿Necesita más ayuda?

¿Quiere más opciones?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

¿Le ha sido útil esta información?

¿Qué ha afectado a su experiencia?
Si presiona Enviar, sus comentarios se usarán para mejorar los productos y servicios de Microsoft. El administrador de TI podrá recopilar estos datos. Declaración de privacidad.

¡Gracias por sus comentarios!

×