Serviço SQLExpress não é possível iniciar Código de erro 17053

1

Um usuário foi instruído pelo suporte de software a atualizar um programa e instalar o SQLExpress como parte do processo de instalação.

Desde então, o serviço pode iniciar, citando o erro 17053, que parece ser um problema de autenticação.

Aqui está o log de erros:

2011-01-11 13:17:45.50 Server      Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) 
    Feb  9 2007 22:47:07 
    Copyright (c) 1988-2005 Microsoft Corporation
    Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2011-01-11 13:17:45.50 Server      (c) 2005 Microsoft Corporation.
2011-01-11 13:17:45.50 Server      All rights reserved.
2011-01-11 13:17:45.50 Server      Server process ID is 3332.
2011-01-11 13:17:45.50 Server      Authentication mode is WINDOWS-ONLY.
2011-01-11 13:17:45.50 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2011-01-11 13:17:45.52 Server      This instance of SQL Server last reported using a process ID of 2332 at 11/10/2010 2:15:24 PM (local) 11/10/2010 7:15:24 PM (UTC). This is an informational message only; no user action is required.
2011-01-11 13:17:45.52 Server      Error: 17053, Severity: 16, State: 1.
2011-01-11 13:17:45.52 Server      UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
2011-01-11 13:17:45.52 Server      Registry startup parameters:
2011-01-11 13:17:45.52 Server        -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2011-01-11 13:17:45.52 Server        -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2011-01-11 13:17:45.52 Server        -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2011-01-11 13:17:45.52 Server      Error: 17113, Severity: 16, State: 1.
2011-01-11 13:17:45.52 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.
2011-01-11 13:17:45.52 Server      Error: 17053, Severity: 16, State: 1.
2011-01-11 13:17:45.52 Server      UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered. 4 Server      Error: 17053, Severity: 16, State: 1.
2011-01-11 13:08:21.34 Server      UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered. 12:47:20.85 spid5s      SQL Trace ID 1 was started by login "sa".
2011-01-11 12:47:20.90 spid5s      Starting up database 'mssqlsystemresource'.
2011-01-11 12:47:20.93 spid5s      The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2011-01-11 12:47:21.21 spid5s      Error: 15466, Severity: 16, State: 1.
2011-01-11 12:47:21.21 spid5s      An error occurred during decryption.
2011-01-11 12:47:21.38 spid8s      Starting up database 'model'.
2011-01-11 12:47:21.38 Server      Error: 17182, Severity: 16, State: 1.
2011-01-11 12:47:21.38 Server      TDSSNIClient initialization failed with error 0x5, status code 0x90.
2011-01-11 12:47:21.38 Server      Error: 17182, Severity: 16, State: 1.
2011-01-11 12:47:21.38 Server      TDSSNIClient initialization failed with error 0x5, status code 0x1.
2011-01-11 12:47:21.38 Server      Error: 17826, Severity: 18, State: 3.
2011-01-11 12:47:21.38 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2011-01-11 12:47:21.38 Server      Error: 17120, Severity: 16, State: 1.
2011-01-11 12:47:21.38 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Um lead que eu tinha era alterar a conta de logon do SQL de "Network Service" para "Local System".

Infelizmente, isso está resultando na mensagem de erro The Security ID Structure is Invalid [0x80070539]

Qualquer ajuda para desinstalar ou executar o SQLExpress seria fantástica.

    
por Chris Sobolewski 11.01.2011 / 19:53

2 respostas

1

O primeiro problema é que parece que o banco de dados mestre foi movido ou excluído, ou a pasta teve todos os direitos removidos da conta do SQL Server.

Suponho que você também tenha os direitos para as chaves reg que o SQL Server precisa atualizar bloqueadas.

    
por 11.01.2011 / 22:31
0

Você pode encontrar esta discussão útil.

    
por 11.01.2011 / 20:52