SQL-Server startet nicht ...

16/09/2008 - 12:12 von Lutz Uhlmann | Report spam
Der SQL-Server lief bis ein Bauarbeiter die Sicherung ausknipste ...

Beim Hochfahren des Servers startet der Server-Dienst nicht und ich bekomme
die folgenden Fehlermeldungen ...

2008-09-16 11:57:43.23 Server Microsoft SQL Server 2005 - 9.00.1399.06
(Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

2008-09-16 11:57:43.23 Server (c) 2005 Microsoft Corporation.
2008-09-16 11:57:43.23 Server All rights reserved.
2008-09-16 11:57:43.23 Server Server process ID is 3732.
2008-09-16 11:57:43.23 Server Logging SQL Server messages in file
'C:\Programme\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2008-09-16 11:57:43.24 Server This instance of SQL Server last reported
using a process ID of 2952 at 16.09.2008 11:52:27 (local) 16.09.2008
09:52:27 (UTC). This is an informational message only; no user action is
required.
2008-09-16 11:57:43.24 Server Registry startup parameters:
2008-09-16 11:57:43.24 Server -d C:\Programme\Microsoft SQL
Server\MSSQL.2\MSSQL\DATA\master.mdf
2008-09-16 11:57:43.24 Server -e C:\Programme\Microsoft SQL
Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2008-09-16 11:57:43.24 Server -l C:\Programme\Microsoft SQL
Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2008-09-16 11:57:43.28 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is
required.
2008-09-16 11:57:43.28 Server Detected 2 CPUs. This is an informational
message; no user action is required.
2008-09-16 11:57:43.53 Server Set AWE Enabled to 1 in the configuration
parameters to allow use of more memory.
2008-09-16 11:57:44.42 Server 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.
2008-09-16 11:57:44.60 Server Attempting to initialize Microsoft
Distributed Transaction Coordinator (MS DTC). This is an informational
message only. No user action is required.
2008-09-16 11:57:44.74 Server The Microsoft Distributed Transaction
Coordinator (MS DTC) service could not be contacted. If you would like
distributed transaction functionality, please start this service.
2008-09-16 11:57:44.76 Server Database Mirroring Transport is disabled
in the endpoint configuration.
2008-09-16 11:57:44.79 spid5s Starting up database 'master'.
2008-09-16 11:57:44.96 spid5s SQL Trace ID 1 was started by login "sa".
2008-09-16 11:57:44.96 spid5s Starting up database
'mssqlsystemresource'.
2008-09-16 11:57:45.18 spid5s Server name is 'SQLDEV'. This is an
informational message only. No user action is required.
2008-09-16 11:57:45.18 spid9s Starting up database 'model'.
2008-09-16 11:57:45.34 spid9s Clearing tempdb database.
2008-09-16 11:57:45.53 Server Fehler: 17190, Schweregrad: 16, Status:
1.
2008-09-16 11:57:45.53 Server FallBack certificate initialization
failed with error code: 1.
2008-09-16 11:57:45.53 Server Fehler: 26015, Schweregrad: 16, Status:
1.
2008-09-16 11:57:45.53 Server Unable to load user-specified
certificate. Because connection encryption is required, the server will not
be able to accept any connections. You should verify that the certificate is
correctly installed. See "Configuring Certificate for Use by SSL" in Books
Online.
2008-09-16 11:57:45.53 Server Fehler: 17182, Schweregrad: 16, Status:
1.
2008-09-16 11:57:45.53 Server TDSSNIClient initialization failed with
error 0x80092004, status code 0x80.
2008-09-16 11:57:45.53 Server Fehler: 17182, Schweregrad: 16, Status:
1.
2008-09-16 11:57:45.53 Server TDSSNIClient initialization failed with
error 0x80092004, status code 0x1.
2008-09-16 11:57:45.53 Server Fehler: 17826, Schweregrad: 18, Status:
3.
2008-09-16 11:57:45.53 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.
2008-09-16 11:57:45.53 Server Fehler: 17120, Schweregrad: 16, Status:
1.
2008-09-16 11:57:45.53 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.

Wir haben keine Extra-zertifikate installiert oder so. Der Server wurde
installiert und so wie er war genutzt.
 

Lesen sie die antworten

#1 Lutz Uhlmann
16/09/2008 - 12:31 | Warnen spam
So kann es erstmal etwas mehr einschrànken ...

HAbe unter SQL Server 2005-Netzwerkkonfiguration -> Protokolle für
'MSSQLSERVER' -> Eigenschaften das Flag ForceEncryption auf 'Nein' gestellt.
Damit startet der Server-Dienst ersteinmal wieder aber er bringt immer noch
Fehler-Meldungen.

2008-09-16 12:22:37.26 Server Microsoft SQL Server 2005 - 9.00.1399.06
(Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

2008-09-16 12:22:37.26 Server (c) 2005 Microsoft Corporation.
2008-09-16 12:22:37.26 Server All rights reserved.
2008-09-16 12:22:37.28 Server Server process ID is 3368.
2008-09-16 12:22:37.28 Server Logging SQL Server messages in file
'C:\Programme\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2008-09-16 12:22:37.28 Server This instance of SQL Server last reported
using a process ID of 2740 at 16.09.2008 12:03:12 (local) 16.09.2008
10:03:12 (UTC). This is an informational message only; no user action is
required.
2008-09-16 12:22:37.28 Server Registry startup parameters:
2008-09-16 12:22:37.28 Server -d C:\Programme\Microsoft SQL
Server\MSSQL.2\MSSQL\DATA\master.mdf
2008-09-16 12:22:37.28 Server -e C:\Programme\Microsoft SQL
Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2008-09-16 12:22:37.28 Server -l C:\Programme\Microsoft SQL
Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2008-09-16 12:22:37.31 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is
required.
2008-09-16 12:22:37.31 Server Detected 2 CPUs. This is an informational
message; no user action is required.
2008-09-16 12:22:37.56 Server Set AWE Enabled to 1 in the configuration
parameters to allow use of more memory.
2008-09-16 12:22:38.45 Server 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.
2008-09-16 12:22:38.64 Server Attempting to initialize Microsoft
Distributed Transaction Coordinator (MS DTC). This is an informational
message only. No user action is required.
2008-09-16 12:22:38.78 Server The Microsoft Distributed Transaction
Coordinator (MS DTC) service could not be contacted. If you would like
distributed transaction functionality, please start this service.
2008-09-16 12:22:38.79 Server Database Mirroring Transport is disabled
in the endpoint configuration.
2008-09-16 12:22:38.82 spid4s Starting up database 'master'.
2008-09-16 12:22:38.98 spid4s SQL Trace ID 1 was started by login "sa".
2008-09-16 12:22:39.00 spid4s Starting up database
'mssqlsystemresource'.
2008-09-16 12:22:39.21 spid4s Server name is 'SQLDEV'. This is an
informational message only. No user action is required.
2008-09-16 12:22:39.26 spid9s Starting up database 'model'.
2008-09-16 12:22:39.57 Server Fehler: 17190, Schweregrad: 16, Status:
1.
2008-09-16 12:22:39.57 Server FallBack certificate initialization
failed with error code: 1.
2008-09-16 12:22:39.57 Server Warning:Encryption is not available,
could not find a valid certificate to load.
2008-09-16 12:22:39.64 spid9s Clearing tempdb database.
2008-09-16 12:22:39.67 Server Server is listening on [ 'any' <ipv4>
1433].
2008-09-16 12:22:39.68 Server Server local connection provider is ready
to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2008-09-16 12:22:39.68 Server Server named pipe provider is ready to
accept connection on [ \\.\pipe\sql\query ].
2008-09-16 12:22:39.76 Server Server is listening on [ 127.0.0.1 <ipv4>
1434].
2008-09-16 12:22:39.78 Server Dedicated admin connection support was
established for listening locally on port 1434.
2008-09-16 12:22:40.07 Server The SQL Network Interface library could
not register the Service Principal Name (SPN) for the SQL Server service.
Error: 0xd. 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.
2008-09-16 12:22:40.07 Server SQL Server is now ready for client
connections. This is an informational message; no user action is required.
2008-09-16 12:22:41.01 spid9s Starting up database 'tempdb'.
2008-09-16 12:22:41.03 spid12s Starting up database 'msdb'.
2008-09-16 12:22:41.03 spid13s Starting up database 'papdata'.
2008-09-16 12:22:41.03 spid14s Starting up database 'AdventureWorks'.
2008-09-16 12:22:41.73 spid14s 10 transactions rolled forward in
database 'AdventureWorks' (6). This is an informational message only. No
user action is required.
2008-09-16 12:22:42.18 spid4s 0 transactions rolled back in database
'AdventureWorks' (6). This is an informational message only. No user action
is required.
2008-09-16 12:22:42.18 spid4s Recovery is writing a checkpoint in
database 'AdventureWorks' (6). This is an informational message only. No
user action is required.
2008-09-16 12:22:42.65 spid12s 28 transactions rolled forward in
database 'msdb' (4). This is an informational message only. No user action
is required.
2008-09-16 12:22:42.84 spid14s The Service Broker protocol transport is
disabled or not configured.
2008-09-16 12:22:42.84 spid14s The Database Mirroring protocol transport
is disabled or not configured.
2008-09-16 12:22:43.01 spid4s 0 transactions rolled back in database
'msdb' (4). This is an informational message only. No user action is
required.
2008-09-16 12:22:43.09 spid4s Recovery is writing a checkpoint in
database 'msdb' (4). This is an informational message only. No user action
is required.
2008-09-16 12:22:43.48 spid14s Service Broker manager has started.
2008-09-16 12:22:45.25 spid13s 118 transactions rolled forward in
database 'papdata' (5). This is an informational message only. No user
action is required.
2008-09-16 12:22:45.37 spid13s 0 transactions rolled back in database
'papdata' (5). This is an informational message only. No user action is
required.
2008-09-16 12:22:45.37 spid13s Recovery is writing a checkpoint in
database 'papdata' (5). This is an informational message only. No user
action is required.
2008-09-16 12:22:45.43 spid4s Recovery is complete. This is an
informational message only. No user action is required.

sowie beim anschliessenden Stoppen des Dienstes ...

2008-09-16 12:25:43.81 spid14s Service Broker manager has shut down.
2008-09-16 12:25:44.57 spid4s SQL Server is terminating in response to
a 'stop' request from Service Control Manager. This is an informational
message only. No user action is required.
2008-09-16 12:25:44.57 spid4s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
2008-09-16 12:25:44.65 Server The SQL Network Interface library could
not deregister the Service Principal Name (SPN) for the SQL Server service.
Error: 0xd. Administrator should deregister this SPN manually to avoid
client authentication errors.

Ähnliche fragen