2-node cluster install fails - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

2-node cluster install fails

Author

Topic

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-07-15 : 01:24:00

Hi,

I was trying to install sql server 2008 on windows server 2008 2-node cluster .

Currently have done only the install on only 1 node and later i want to perform add node.

But now, i am currently stuck with the below error.

The cluster resource 'SQL Server' could not be brought online.
Error: The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)

Searched in Google found a blog on this and i want opt for option - 1.

http://blogs.msdn.com/b/karthick_pk/archive/2009/03/27/installation-of-sqlserver2008-cluster-fails-on-windows2008-the-group-or-resource-is-not-in-the-correct-state-to-perform-the-requested-operation-exception-from-hresult-0x8007139f.aspx

Now my question is, do we need to create the SPN's manually on both the nodes ?????? or do we need to create in Active Directory machine ? or on node1 first before install and on node 2 before Add node operation??? which way i need to proceed.

Thanks in Advance.

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-07-18 : 07:33:45

Hi,

Created the SPN's in Active Directory but still SQL Server failed to come online.

I have created the SPN's for both Netbios name and fully qualified domain name for SQL server network name with a default port no :1433. but still am getting below errors in sql errorlog. OS is windows Server 2008, sp1 and SQL server 2008 R2

2011-07-15 15:59:32.40 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.40 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.40 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.40 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.41 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.41 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.41 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.41 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.42 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.42 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT:

2011-07-15 15:59:32.42 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.42 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.43 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.43 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.43 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.43 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.44 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.44 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT:]
2011-07-15 15:59:32.44 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.44 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:32.45 Logon Error: 18456, Severity: 14, State: 11.
2011-07-15 15:59:32.45 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
2011-07-15 15:59:35.13 spid16s Service Broker manager has shut down.
2011-07-15 15:59:35.15 spid8s 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.
2011-07-15 15:59:35.15 spid8s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources