Starting SQL Server Resource Group failed

Giganews Newsgroups
Subject: Starting SQL Server Resource Group failed
Posted by:  Karsten (Karst…@discussions.microsoft.com)
Date: Thu, 10 May 2007

Hello!

I´ve got some problems with starting a SQL Server 2005 Resource Group on a
failover cluster.

The installation of the Virtual SQL Server 2005 went well, except the message
"All resources did not come online and therefore you will need to manually
set the cluster restart option."
But the installation completed successfully.

If I want to bring the Resource Group online, the SQL Server Starts, but a
few seconds later it is stopped by the cluster.
The SQL Server Resource doesn´t stay online. The ClusterAdministrator
account wasn´t able to connect to the Instance, so the CheckServiceAlive
Process failed.

I´ve installed a few more instances on this cluster - all exactly the same
way. But some of the resource groups are able to start after installation -
and others not.

Operating System:    Windows Server 2003 Enterprise x64 Edition - SP1
SQL Server:    SQL Server 2005 Enterprise Edition (x64), German

Do you have any ideas how to solve this problem?

Summary about the Events:
--------------------------------
1. Bring SQL2005 group online...

Application Log:

2. SQLBrowser Warning Event ID 3:    The configuration of the
AdminConnection\TCP protocol in the SQL instance i05 is not valid.

3. MSSQL$i05 Info Event ID 26022:     Server is listening on ...

4. MSSQL$i05 Info Event ID 26037:     The SQL Network Interface library was
unable to register SPN.

5. MSSQL$i05 Info Event ID 17126:    SQL Server is ready for client connections

6. MSSQL$i05 ERROR Event ID 18456:    Login failed for user
'ClusterDomain\ClusterAdmin'

7. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] ODBC sqldriverconnect failed

8. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] checkODBCConnectError
....

9. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] OnlineThread: Error connecting
to SQL Server.

10. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] OnlineThread: did not connect
after 10 attempts resource failed

11. MSSQL$i05 Info Event ID 17148:    Als Antwort auf die Stop-Anforderung des
Dienstkontroll-Managers wird SQL Server beendet.

12. MSSQL$i05 Info Event ID 26038:    "The SQL Network Interface library was
unable to unregister SPN."

13. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] CheckServiceAlive: Service is
dead

14. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] OnlineThread: service stopped
while waiting for QP.

15. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] OnlineThread: Error 1
bringing resource online.

16. MSSQL$i05 ERROR Event ID 19019:    [sqsrvres] CheckServiceAlive: Service is
dead

System Log:

- ClusSvc / Failover Mgr  ERROR Event ID 1069:    Cluster resource 'SQL Server
(i05)' in Resource Group 'SQL90group5' failed.

- ClusSvc / Failover Mgr  Info Event ID 1205:    The Cluster Service failed to
bring the Resource Group "SQL90group5" completely online or offline.

Details:
--------

APPLICATION Log:

Event Type:    Warning
Event Source:    SQLBrowser
Event Category:    None
Event ID:    3
Date:        10.05.2007
Time:        12:31:24
User:        N/A
Computer:    NODE1
Description:
Die Konfiguration des AdminConnection\TCP-Protokolls in der SQL-Instanz i05
ist ungültig.

Event Type:    Information
Event Source:    MSSQL$i05
Event Category:    (2)
Event ID:    26022
Date:        10.05.2007
Time:        12:31:26
User:        N/A
Computer:    virtualSQLserver
Description:
Der Server überwacht [ 10.0.0.8 <ipv4> 1640].

Event Type:    Information
Event Source:    MSSQL$i05
Event Category:    (2)
Event ID:    26037
Date:        10.05.2007
Time:        12:31:26
User:        N/A
Computer:    virtualSQLserver
Description:
Von der SQL-Netzwerkschnittstellenbibliothek konnte der Dienstprinzipalname
(Service Principal Name, SPN) für den SQL Server-Dienst nicht registriert
werden. Fehler: 0x2098. Wenn ein SPN nicht registriert werden kann, wird die
integrierte Authentifizierung möglicherweise auf NTLM statt Kerberos
zurückgesetzt. Diese Meldung dient nur zu Informationszwecken. Weitere
Aktionen sind nur notwendig, wenn die Kerberos-Authentifizierung laut
Authentifizierungsrichtlinien erforderlich ist.

Event Type:    Information
Event Source:    MSSQL$i05
Event Category:    (2)
Event ID:    17126
Date:        10.05.2007
Time:        12:31:26
User:        N/A
Computer:    virtualSQLserver
Description:
SQL Server ist nun bereit für Clientverbindungen. Diese Meldung dient nur zu
Informationszwecken. Es ist keine Benutzeraktion erforderlich.

Event Type:    Failure Audit
Event Source:    MSSQL$i05
Event Category:    (4)
Event ID:    18456
Date:        10.05.2007
Time:        12:31:26
User:        ClusterDomain\ClusterAdmin
Computer:    virtualSQLserver
Description:
Fehler bei der Anmeldung für den Benutzer 'ClusterDomain\ClusterAdmin'.
[CLIENT: 10.0.0.8]

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:26
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] ODBC sqldriverconnect failed

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:26
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818;
message = [Microsoft][SQL Native Client][SQL Server]Login failed for user
'ClusterDomain\ClusterAdmin'.

.............

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:46
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] OnlineThread: Error connecting to SQL Server.

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:48
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] OnlineThread: did not connect after 10 attempts resource failed

Event Type:    Information
Event Source:    MSSQL$i05
Event Category:    (2)
Event ID:    17148
Date:        10.05.2007
Time:        12:31:48
User:        N/A
Computer:    virtualSQLserver
Description:
Als Antwort auf die Stop-Anforderung des Dienstkontroll-Managers wird SQL
Server beendet. Diese Meldung dient nur zu Informationszwecken. Es ist keine
Benutzeraktion erforderlich.

Event Type:    Information
Event Source:    MSSQL$i05
Event Category:    (2)
Event ID:    26038
Date:        10.05.2007
Time:        12:31:48
User:        N/A
Computer:    virtualSQLserver
Description:
Von der SQL-Netzwerkschnittstellenbibliothek konnte die Registrierung des
Dienstprinzipalnamens (Service Principal Name, SPN) für den SQL Server-Dienst
nicht aufgehoben werden. Fehler: 0x2098. Zur Vermeidung von
Clientauthentifizierungsfehlern sollte ein Administrator die Registrierung
dieses SPN manuell aufheben.

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:49
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] CheckServiceAlive: Service is dead

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:49
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] OnlineThread: service stopped while waiting for QP.

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:49
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] OnlineThread: Error 1 bringing resource online.

Event Type:    Error
Event Source:    MSSQL$i05
Event Category:    (3)
Event ID:    19019
Date:        10.05.2007
Time:        12:31:49
User:        N/A
Computer:    NODE1
Description:
[sqsrvres] CheckServiceAlive: Service is dead

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

SYSTEM Log:

Event Type:    Information
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7035
Date:        10.05.2007
Time:        12:31:23
User:        ClusterDomain\ClusterAdmin
Computer:    NODE1
Description:
The SQL Server (i05) service was successfully sent a start control.

Event Type:    Information
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7036
Date:        10.05.2007
Time:        12:31:26
User:        N/A
Computer:    NODE1
Description:
The SQL Server (i05) service entered the running state.

............

Event Type:    Information
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7035
Date:        10.05.2007
Time:        12:31:48
User:        ClusterDomain\ClusterAdmin
Computer:    NODE1
Description:
The SQL Server (i05) service was successfully sent a stop control.

Event Type:    Information
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7036
Date:        10.05.2007
Time:        12:31:48
User:        N/A
Computer:    NODE1
Description:
The SQL Server (i05) service entered the stopped state.

Event Type:    Error
Event Source:    ClusSvc
Event Category:    Failover Mgr
Event ID:    1069
Date:        10.05.2007
Time:        12:31:49
User:        N/A
Computer:    NODE1
Description:
Cluster resource 'SQL Server (i05)' in Resource Group 'SQL90group5' failed.

Event Type:    Information
Event Source:    ClusSvc
Event Category:    Failover Mgr
Event ID:    1205
Date:        10.05.2007
Time:        12:31:49
User:        N/A
Computer:    NODE1
Description:
The Cluster Service failed to bring the Resource Group "SQL90group5"
completely online or offline.

Replies