SQL servers agent service failure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » SQL servers agent service failure

SQL servers agent service failure

Rate Topic

Display Mode

Topic Options

Author

Message

Simha24

Posted Thursday, December 27, 2012 8:08 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 94, Visits: 319

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

Post #1400779

faisalfarouqi

Posted Wednesday, January 23, 2013 7:53 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:14 AM
Points: 74, Visits: 464

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

Post #1410598

« Prev Topic | Next Topic »

Permissions