2010-06-07 14:29:43.04 Server All rights reserved.
2010-06-07 14:29:43.04 Server Server process ID is 2476.
2010-06-07 14:29:43.04 Server Logging SQL Server messages in file 'c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-06-07 14:29:43.04 Server This instance of SQL Server last reported using a process ID of 388 at 7/6/2010 10:31:36 (local) 7/6/2010 13:31:36 (UTC). This is an informational message only; no user action is required.
2010-06-07 14:29:43.04 Server Registry startup parameters:
2010-06-07 14:29:43.04 Server -d c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-06-07 14:29:43.04 Server -e c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-06-07 14:29:43.04 Server -l c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-06-07 14:29:43.07 Servidor SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-06-07 14:29:43.07 Servidor Detected 1 CPUs. This is an informational message; no user action is required.
2010-06-07 14:29:44.25 Servidor Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-06-07 14:29:44.31 Servidor Database Mirroring Transport is disabled in the endpoint configuration.
2010-06-07 14:29:44.84 spid5s Starting up database 'master'.
2010-06-07 14:29:45.87 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-06-07 14:29:47.65 spid5s SQL Trace ID 1 was started by login "sa".
2010-06-07 14:29:48.21 spid5s Starting up database 'mssqlsystemresource'.
2010-06-07 14:29:50.03 spid8s Starting up database 'model'.
2010-06-07 14:29:50.07 spid5s Server name is 'RENATA\SQLEXPRESS'. This is an informational message only. No user action is required.
2010-06-07 14:29:50.12 Servidor Virtual Interface Architecture protocol is not supported for this particular edition of SQL Server.
2010-06-07 14:29:50.21 spid5s Starting up database 'msdb'.
2010-06-07 14:29:50.90 Servidor A self-generated certificate was successfully loaded for encryption.
2010-06-07 14:29:51.00 Servidor Server is listening on [ 'any' <ipv4> 1084].
2010-06-07 14:29:51.00 Servidor Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2010-06-07 14:29:51.00 Servidor Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
2010-06-07 14:29:51.03 Servidor Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2010-06-07 14:29:51.14 Servidor The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-06-07 14:29:51.14 Servidor SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-06-07 14:29:52.81 spid8s Starting up database 'tempdb'.
2010-06-07 14:29:53.15 spid5s Recovery is complete. This is an informational message only. No user action is required.
2010-06-07 14:29:53.40 spid11s The Service Broker protocol transport is disabled or not configured.
2010-06-07 14:29:53.43 spid11s The Database Mirroring protocol transport is disabled or not configured.
2010-06-07 14:29:54.18 spid11s Service Broker manager has started.
2010-06-07 14:32:24.85 Servidor Server resumed execution after being idle 120 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2010-06-07 14:32:27.07 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-06-07 14:34:47.43 spid51 Starting up database 'Vetorh'.
2010-06-07 14:37:45.03 Servidor SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2010-06-07 14:37:45.93 spid11s Service Broker manager has shut down.
2010-06-07 14:37:46.00 spid11s The current event was not reported to the Windows Events log. Operating system error = 1717(Interface desconhecida.). You may need to clear the Windows Events log if it is full.
2010-06-07 14:37:47.18 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2010-06-07 14:37:47.23 Servidor The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
Pergunta
Lucas Senior
Olá pessoal, bom dia!
Bom, hoje pela manhã, um cliente aqui de nossa empresa, me informou que ao tentar inicializar o Sistema (rh), foi apresentado um erro.
Logo, fiz uma conexão no mesmo e constatei que os erviço SQLServer estava parado.
Ao tentar inicializá-lo, tive o erro abaixo.
http://img535.imageshack.us/img535/1064/errol.jpg
Em seguida, verifiquei os logs:
Segue conteúdos:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERRORLOG
2010-06-07 14:29:43.04 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright © 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2010-06-07 14:29:43.04 Server © 2005 Microsoft Corporation.
2010-06-07 14:29:43.04 Server All rights reserved.
2010-06-07 14:29:43.04 Server Server process ID is 2476.
2010-06-07 14:29:43.04 Server Logging SQL Server messages in file 'c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-06-07 14:29:43.04 Server This instance of SQL Server last reported using a process ID of 388 at 7/6/2010 10:31:36 (local) 7/6/2010 13:31:36 (UTC). This is an informational message only; no user action is required.
2010-06-07 14:29:43.04 Server Registry startup parameters:
2010-06-07 14:29:43.04 Server -d c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-06-07 14:29:43.04 Server -e c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-06-07 14:29:43.04 Server -l c:\Arquivos de programas\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-06-07 14:29:43.07 Servidor SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-06-07 14:29:43.07 Servidor Detected 1 CPUs. This is an informational message; no user action is required.
2010-06-07 14:29:44.25 Servidor Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-06-07 14:29:44.31 Servidor Database Mirroring Transport is disabled in the endpoint configuration.
2010-06-07 14:29:44.84 spid5s Starting up database 'master'.
2010-06-07 14:29:45.87 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-06-07 14:29:47.65 spid5s SQL Trace ID 1 was started by login "sa".
2010-06-07 14:29:48.21 spid5s Starting up database 'mssqlsystemresource'.
2010-06-07 14:29:50.03 spid8s Starting up database 'model'.
2010-06-07 14:29:50.07 spid5s Server name is 'RENATA\SQLEXPRESS'. This is an informational message only. No user action is required.
2010-06-07 14:29:50.12 Servidor Virtual Interface Architecture protocol is not supported for this particular edition of SQL Server.
2010-06-07 14:29:50.21 spid5s Starting up database 'msdb'.
2010-06-07 14:29:50.90 Servidor A self-generated certificate was successfully loaded for encryption.
2010-06-07 14:29:51.00 Servidor Server is listening on [ 'any' <ipv4> 1084].
2010-06-07 14:29:51.00 Servidor Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLEXPRESS ].
2010-06-07 14:29:51.00 Servidor Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLEXPRESS\sql\query ].
2010-06-07 14:29:51.03 Servidor Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2010-06-07 14:29:51.14 Servidor The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-06-07 14:29:51.14 Servidor SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-06-07 14:29:51.49 spid8s Clearing tempdb database.
2010-06-07 14:29:52.81 spid8s Starting up database 'tempdb'.
2010-06-07 14:29:53.15 spid5s Recovery is complete. This is an informational message only. No user action is required.
2010-06-07 14:29:53.40 spid11s The Service Broker protocol transport is disabled or not configured.
2010-06-07 14:29:53.43 spid11s The Database Mirroring protocol transport is disabled or not configured.
2010-06-07 14:29:54.18 spid11s Service Broker manager has started.
2010-06-07 14:32:24.85 Servidor Server resumed execution after being idle 120 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2010-06-07 14:32:27.07 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-06-07 14:34:47.43 spid51 Starting up database 'Vetorh'.
2010-06-07 14:37:45.03 Servidor SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2010-06-07 14:37:45.93 spid11s Service Broker manager has shut down.
2010-06-07 14:37:46.00 spid11s Error: 17054, Severity: 16, State: 1.
2010-06-07 14:37:46.00 spid11s The current event was not reported to the Windows Events log. Operating system error = 1717(Interface desconhecida.). You may need to clear the Windows Events log if it is full.
2010-06-07 14:37:47.18 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2010-06-07 14:37:47.23 Servidor The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Exceptionlog:
06/02/10 08:01:30 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/02/10 10:21:28 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/04/10 08:03:54 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/06/10 13:55:18 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/07/10 08:00:21 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/07/10 10:10:55 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/07/10 10:12:43 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/07/10 10:15:27 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/07/10 10:16:56 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/07/10 10:31:38 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
06/07/10 14:39:44 spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 8B0034F0 at 0x011C854D
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Erro ao inicializar o Sistema:
http://img405.imageshack.us/img405/9738/erro2f.jpg
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Estou com esse problema desde as 08:00 da manhã e não consigo resolvê-lo...
Já liberei todos os tipos de acesso (TCP/VIA/Pipes nomeados).
O "Servidor" é um Windows XP em SP3.
Banco de Dados: SQLServer 2005 Express Edition
Desde já agradeço o apoio.
Como é meu primeiro contato com o fórum, deixo aqui minha disponibilidade em poder ajudar.
Abraço.
Att
Lucas Alves.
Link para o comentário
Compartilhar em outros sites
7 respostass a esta questão
Posts Recomendados
Participe da discussão
Você pode postar agora e se registrar depois. Se você já tem uma conta, acesse agora para postar com sua conta.