O SQL Server 2005 não inicia após a instalação do SP3

Question

Eu tenho um problema bem ridículo.

Então eu instalei o SQL Server 2005 em uma máquina com o Windows Server 2008. Eu estava trabalhando nos service packs, provisionando dois usuários para ter direitos totais sobre o banco de dados SQL.

Instalei o SP3, reiniciei e agora não consigo iniciar nenhum dos serviços SQL. Quando tento logar no SQL Management Studio, ele me diz que conexões remotas não são permitidas (são 100% seguras) e me da mensagem de erro 2.

Eu não tenho a menor idéia de por que isso estaria acontecendo, então qualquer ajuda, mesmo na compreensão da natureza desse problema, seria útil.

Log Name: System
Source: Service
Control Manager Date: 2/9/2010 9:29:07 AM
Event ID: 7041 Task
Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: forefronttest.mca.xxxx.xxxx Description: The MSSQLSERVER service was unable to log on as MCA\forefront with the currently configured password due to the following error: Logon failure: the user has not been granted the requested logon type at this computer.
Service: MSSQLSERVER Domain and account: MCA\forefront
This service account does not have the required user right "Log on as a service."

User Action
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.

If you have already assigned this user right to the service account, and the user right appears to be removed, check with your domain administrator to find out if a Group Policy object associated with this node might be removing the right.

Event Xml:

 <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
     <Provider Name="Service Control Manager" Guid="{555908D1-A6D7-4695-8E1E-26931D2012F4}" EventSourceName="Service Control Manager" />
        <EventID Qualifiers="49152">7041</EventID>
        <Version>0</Version>
        <Level>2</Level>
        <Task>0</Task>
        <Opcode>0</Opcode>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2010-02-09T17:29:07.000Z" />
        <EventRecordID>1938</EventRecordID>
        <Correlation />
        <Execution ProcessID="0" ThreadID="0" />
        <Channel>System</Channel>
        <Computer>forefronttest.mca.xxxx.xxxx</Computer>
        <Security />
     </System>
     <EventData>
        <Data Name="param1">MSSQLSERVER</Data>
        <Data Name="param2">MCA\forefront</Data>
     </EventData>
 </Event>

    

Answer 1

net localgroup SQLServerMSSQLUser$forefronttest$MSSQLSERVER /add MCA\forefront

Isso adicionará o usuário do MCA \ ao grupo local criado durante a instalação do SQL que possui todos os privilégios necessários para executar o serviço do SQL Server. Consulte Como configurar contas de serviço do Windows .