Re: Starting SQL Server Resource Group failed

Can you post the SQL Error log (ERRORLOG) file in english?

Ayad

"Karsten" <Karsten@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7FA75AE6-6D34-40B4-88DA-4E6645480270@xxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: SQL Service Not Starting
    ... Event Type: Information ... Event Source: MSSQLSERVER ... SQL Server is starting at priority class 'normal'(2 CPUs ...
    (microsoft.public.sqlserver.security)
  • SQL Service Not Starting
    ... Event Type: Information ... Event Source: MSSQLSERVER ... SQL Server is starting at priority class 'normal'(2 CPUs ...
    (microsoft.public.sqlserver.security)
  • Cluster resource SQL Server Fulltext in Resource Group SERVER failed.
    ... Event Type: Error ... Event Source: ClusSvc ... Cluster resource 'SQL Server Fulltext' in Resource Group 'SQL1' failed. ...
    (microsoft.public.sqlserver.clustering)
  • Errors in Event Log
    ... Event Type: Error ... Event Source: MSSQLSERVER ... SQL Server is terminating this process. ...
    (microsoft.public.sqlserver.server)
  • Starting SQL Server Resource Group failed
    ... The installation of the Virtual SQL Server 2005 went well, ... "All resources did not come online and therefore you will need to manually ... set the cluster restart option." ... If I want to bring the Resource Group online, the SQL Server Starts, but a ...
    (microsoft.public.sqlserver.clustering)