Re: Starting SQL Server Resource Group failed

From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
Date: Thu, 24 May 2007 11:28:57 -0400

It looks like the Cluster Service cannot connect to the SQL Service to determine whether it is responsive or not. This is an essential function of the cluster service and is used to determine if a failover is necessary.

From your other posts in this thread, it sound like the permissions on the

domain groups used by SQL to control permissions across all cluster nodes did not get set correctly. At this time, MS has not documented a process to fix this without uninstalling and reinstalling SQL Server.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Karsten" <Karsten@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:95305DC7-3E23-4E09-A347-AB11D2C84087@xxxxxxxxxxxxxxxx

Hello Ayad!

Here´s the content of the ERRORLOG File...
------------------------------------------------------------------------------------------
2007-05-23 14:07:38.15 Server Microsoft SQL Server 2005 - 9.00.1399.06
(X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-05-23 14:07:38.15 Server (c) 2005 Microsoft Corporation.
2007-05-23 14:07:38.15 Server All rights reserved.
2007-05-23 14:07:38.15 Server Server process ID is 2100.
2007-05-23 14:07:38.15 Server Logging SQL Server messages in file
'M:\SQL90group5Data\Microsoft SQL Server\MSSQL.5\MSSQL\LOG\ERRORLOG'.
2007-05-23 14:07:38.15 Server This instance of SQL Server last reported
using a process ID of 6044 at 5/10/2007 12:31:48 PM (local) 5/10/2007
10:31:48 AM (UTC). This is an informational message only; no user action is
required.
2007-05-23 14:07:38.15 Server Registry startup parameters:
2007-05-23 14:07:38.15 Server -d M:\SQL90group5Data\Microsoft SQL
Server\MSSQL.5\MSSQL\DATA\master.mdf
2007-05-23 14:07:38.15 Server -e M:\SQL90group5Data\Microsoft SQL
Server\MSSQL.5\MSSQL\LOG\ERRORLOG
2007-05-23 14:07:38.15 Server -l M:\SQL90group5Data\Microsoft SQL
Server\MSSQL.5\MSSQL\DATA\mastlog.ldf
2007-05-23 14:07:38.23 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is required.
2007-05-23 14:07:38.23 Server Detected 2 CPUs. This is an informational
message; no user action is required.
2007-05-23 14:07:38.62 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.
2007-05-23 14:07:38.93 Server Attempting to initialize Microsoft
Distributed Transaction Coordinator (MS DTC). This is an informational
message only. No user action is required.
2007-05-23 14:07:40.10 Server Attempting to recover in-doubt
distributed transactions involving Microsoft Distributed Transaction
Coordinator (MS DTC). This is an informational message only. No user action
is required.
2007-05-23 14:07:40.12 Server Database Mirroring Transport is disabled
in the endpoint configuration.
2007-05-23 14:07:40.23 spid5s Starting up database 'master'.
2007-05-23 14:07:40.51 spid5s Recovery is writing a checkpoint in
database 'master' (1). This is an informational message only. No user action
is required.
2007-05-23 14:07:40.65 spid5s SQL Trace ID 1 was started by login "sa".
2007-05-23 14:07:40.70 spid5s Starting up database 'mssqlsystemresource'.
2007-05-23 14:07:40.93 spid5s Server name is 'virtualSQLserver\i05'.
This is an informational message only. No user action is required.
2007-05-23 14:07:40.93 spid9s Starting up database 'model'.
2007-05-23 14:07:40.93 spid5s The NETBIOS name of the local node that
is running the server is 'NODE1'. This is an informational message only. No
user action is required.
2007-05-23 14:07:41.01 spid9s Clearing tempdb database.
2007-05-23 14:07:41.12 Server A self-generated certificate was
successfully loaded for encryption.
2007-05-23 14:07:41.12 Server Server is listening on [ 10.0.0.8 <ipv4>
1640].
2007-05-23 14:07:41.14 Server Server local connection provider is ready
to accept connection on [ \\.\pipe\SQLLocal\i05 ].
2007-05-23 14:07:41.14 Server Server named pipe provider is ready to
accept connection on [ \\.\pipe\$$\virtualSQLserver\MSSQL$i05\sql\query ].
2007-05-23 14:07:41.17 Server The SQL Network Interface library could
not register the Service Principal Name (SPN) for the SQL Server service.
Error: 0x2098. 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.
2007-05-23 14:07:41.17 Server SQL Server is now ready for client
connections. This is an informational message; no user action is required.
2007-05-23 14:07:41.17 spid9s Starting up database 'tempdb'.
2007-05-23 14:07:41.29 spid12s The Service Broker protocol transport is
disabled or not configured.
2007-05-23 14:07:41.29 spid12s The Database Mirroring protocol transport
is disabled or not configured.
2007-05-23 14:07:41.39 spid5s Starting up database 'msdb'.
2007-05-23 14:07:41.40 spid12s Service Broker manager has started.
2007-05-23 14:07:41.40 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.40 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.42 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.42 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.42 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.42 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.43 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.43 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.43 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.43 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.43 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.43 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:41.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:41.50 spid5s Recovery of any in-doubt distributed
transactions involving Microsoft Distributed Transaction Coordinator (MS DTC)
has completed. This is an informational message only. No user action is
required.
2007-05-23 14:07:41.50 spid5s Recovery is complete. This is an
informational message only. No user action is required.
2007-05-23 14:07:43.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.45 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.45 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.46 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.46 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.46 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.46 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.46 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.46 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.46 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.46 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.46 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.46 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:43.46 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:43.46 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.47 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.47 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.47 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.47 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.47 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.47 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.47 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.47 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.47 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.47 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.47 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.47 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:45.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:45.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.48 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.48 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:47.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:47.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.50 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.50 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:49.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:49.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.52 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.52 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:51.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:51.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.53 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.53 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:53.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:53.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.55 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.55 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:55.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:55.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.57 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.57 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:57.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:57.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.58 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.58 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:07:59.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:07:59.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.60 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.60 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.62 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.62 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.62 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.62 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.62 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.62 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.62 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.62 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:01.62 Logon Error: 18456, Severity: 14, State: 11.
2007-05-23 14:08:01.62 Logon Login failed for user
'ClusterDomain\ClusterAdmin'. [CLIENT: 10.0.0.8]
2007-05-23 14:08:03.65 spid12s Service Broker manager has shut down.
2007-05-23 14:08:03.73 spid5s 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.
2007-05-23 14:08:03.73 spid5s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
2007-05-23 14:08:03.73 Server The SQL Network Interface library could
not deregister the Service Principal Name (SPN) for the SQL Server service.
Error: 0x2098. Administrator should deregister this SPN manually to avoid
client authentication errors.

--------------------------------------------------------------------------------------

The Installation of the five SQL Server Instances completed in principal
without errors. But two of the five instances weren´t able to be brought
online. All instances were installed exactly the same way. Only the names,
Service-Accounts (except ClusterAdmin) and IPs were different. It seems, that
the ClusterAdmin does not have the privilege to log on to the SQL Server
Instance or the Group "Administrators" doesn´t have. But to change this, the
service of this instance must be able to start.

I hope you´ll have an idea!

Thanks in advance.

Karsten

References:
- Starting SQL Server Resource Group failed
  - From: Karsten
- Re: Starting SQL Server Resource Group failed
  - From: Ayad Shammout
- Re: Starting SQL Server Resource Group failed
  - From: Karsten

Prev by Date: RE: SQLBrowser Error installing SQL2005 Failover Cluster -x64
Next by Date: Re: A little help with clustered SQL server setup.
Previous by thread: Re: Starting SQL Server Resource Group failed
Next by thread: RE: Starting SQL Server Resource Group failed
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Sever 2008 RC0 fail to install almost all services
... > SQL server services. ... This is an informational message only. ... no user action is required. ...
(microsoft.public.sqlserver.setup)
Cannot move msdb/model even with -T3608
... Our SQL instance is a named one and has the following ... This is an informational message only. ... no user action is required. ... System databases master, model, msdb, and tempdb cannot be detached. ...
(comp.databases.ms-sqlserver)
SQL Issues with winserver 2003 small business standard
... I have a 2003 small business server, a few days ago it was working perfect ... sql, i noticed that the sql service has stopped i tried to start but i ... This is an informational message only; no user action is required. ...
(microsoft.public.windows.server.sbs)
SQL Server 2005 Logon Issues
... an ASP.NET 2.0 application to connect to a SQL Server 2005 database... ... Microsoft Analysis Services Client Tools 2005.090.3042.00 ... This is an informational message only; no user action is required. ...
(microsoft.public.dotnet.framework.aspnet)
Re: SQL Server Express 2005 setup crash!!
... Mike Epprecht, Microsoft SQL Server MVP ... > Mike Epprecht, Microsoft SQL Server MVP ... This is an informational message only. ... no user action is required. ...
(microsoft.public.sqlserver.setup)