December 27, 2012 at 8:08 pm
I am installing SQL server on cluster but SQL Agent has failed to comeonline with bellow errors in event log.
Cluster event :
This issue occurs because the Cluster service does not register the fully qualified domain names (FQDN) of a resource name to the Local Security Authority (LSA).
The Cluster service registers the FQDN of a resource name to LSA and to the DNS database at the same time. However, the DNS registration occurs one time every 24 hours. Therefore, there is a delay in the registration of the FQDN to LSA.
Due to this i am unnable to bring resouces online on NODE1
Error in event log :
Log Name: Application
Source: MSSQLSERVER
Date: date
Event ID: 18456
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: user name
Computer: computer name
Description:
Login failed for user user name. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: IP address]
Log Name: Application
Source: SQLSERVERAGENT
Date: date
Event ID: 53
Task Category: Failover
Level: Error Keywords: Classic
User: N/A
Computer: computer name
Description:
[sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service. CurrentState: 1
Edited: Yesterday @ 11:31:49 PM by Simha24
January 23, 2013 at 7:54 am
Try disabling UAC:
Here is the complete process on how to proceed with this:
Go to Command prompt and run the below command to disable the UAC
Reg.exe ADD HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System /v EnableLUA /t REG_DWORD /d 0 /f
Other way of doing the same is Go to Registry Editor
Start --> Run -->Type RegEdit and hit Enter key
In the Registry Editor, Navigate to the below folder
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
Right click on system folder and place the mouse pointer on New --> click on "DWORD Value" (New Value will be created under System) -->Rename it as "EnableLUA" and default value will be 0 leave as it is.
Then restart your computer. Now you will start getting nagging prompts to re-enable UAC, if needed you can disable these prompts. To avoid this click the bubble at the side, it should say “Change the way Security Center alerts me”, click that, and then click “Don’t notify me and don’t display the icon”.
This should solve the issue.
Regards,
Faisal
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply