July 14, 2011 at 11:24 pm
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.
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.
July 18, 2011 at 5:32 am
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.
July 18, 2011 at 5:37 am
what version of SQL Server 2008 are you installing?
Have you thought of slipstreaming any updates or using a drop merged media?
I do seem to remember this being an issue with SQL Server 2008 install :unsure:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 6:10 am
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
July 19, 2011 at 10:35 am
I faced same problem installing 2008 sql server on windows 2008 R2 server
My problem solved by doing Slip stream installation
check this
July 19, 2011 at 12:00 pm
Ya for SQL 2008 its true. slipstream would work.
But mine is SQL Server 2008 R2.
July 19, 2011 at 12:08 pm
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: ]
i got this error
but solved by using this
Setspn -A MSSQLSvc/SSSING2xxxxx.paxxx.abc.net:INST3 paxxx\Sqlcsxxxxxx01
Setspn -A MSSQLSvc/SSSING2xxxxx.paxxx.abc.net:1454 paxxx\Sqlcsxxxxxxx01
running in cmd
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply