Skip to main content

SQLServerAgent could not be started (reason: Unable to connect to server 'ServerName\Instancename'; SQLServerAgent cannot start).

Hello,

At one of the environments i faced a very strange issue, i was working on SQL Server cluster that was working fine, but for some reason i have to perform a failover, all the resources and services were restarted successfully except for the SQL Server Agent service... looking at the system logs of the vent viewer i found the following error, Event ID 103 "
SQLServerAgent could not be started (reason: Unable to connect to server 'ServerName\Instancename'; SQLServerAgent cannot start)."

Log Name:      Application
Source:        SQLAgent$InstaceName
Date:          3/20/2013 3:29:58 PM
Event ID:      103
Task Category: Service Control
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ServerName
Description:
SQLServerAgent could not be started (reason: Unable to connect to server 'ServerName\InstanceName'; SQLServerAgent cannot start).
Event Xml:
http://schemas.microsoft.com/win/2004/08/events/event
">
 
   
    103
    2
    2
    0x80000000000000
   
    22958
    Application
    ServeraName
   
 
 
    Unable to connect to server 'ServerName\InstanceName'; SQLServerAgent cannot start
 
A quick search on the Internet yielded some forum posts that talk about permission on the SQL drives, and this was not my case.
After some troubleshooting i looked at the account used by the SQL Server Agent Service, the account was OK, but looking at SQL server logs i fount the root cause !
Login failed for user 'Domain\ServiceAccount'. Reason: The account is disabled. [CLIENT: IP Address]
looking at the SQL logins I found out that the login for this account has been disabled by the DBA !!! :(

enabling the account solved the  problem and the service can start successfully

Regards
Amr

Comments

Post a Comment

Popular posts from this blog

Exchange 2010 - EMC "RBAC authorization returns Access Denied"

I was doing an Upgrade for Exchange 2003 to Exchange 2010 and after i installed the first CAS server and opened the EMC an error appeared that i have no permissions... while i was logged in with the setup account and it was a memeber of the Organization Managemnet Group. and i founbd this in the Applicaiton Log  "(Process w3wp.exe, PID 6716) "RBAC authorization returns Access Denied for user Udomain.Local/Users/AccountName. Reason: No role assignments associated with the specified user were found on Domain Controller XXXXX" " After alot of searches i was pulling my remaining hair out :)  I  found this post ( http://social.technet.microsoft.com/Forums/en-US/exchange2010/thread/fc568cc6-8691-4127-b70b-bcc82f9b1f7f?prof=required ) The issue was with 2 things : Allow inheritable permissions check Box was not enabled on the Exchange  Microsoft Exchange Organzaiton container inside the Configuration partition. The value for the attributes msExchRoleLink ...
Post a Comment
Read more

Upgrade from Lync Evaluation edition to Lync RTM.

If you have installed Lync Server using the 180 Day  trial bits  you can upgrade to the RTM bits nsing the following easy steps: Run setup.exe on your Lync server Volume License media. Click on "Install or Update Lync server system" Click on "Setup or remove Lync server components" Open CMD and  navigate to \Setup\amd64\setup and then run msiexec.exe /fvomus server.msi EVALTOFULL=1 /qb  Open Lync Server Management Shell and then run Enable-CSComputer and then you are done !
7 comments
Read more

(A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.

I was deploying a Lync Server Director in a Multi-Tenant configuration after i assigned the certificate a went to start the services, the Front-End services couldn't start with the following errors Log Name:      Lync Server Source:        LS Protocol Stack Date:          3/12/2013 1:52:06 PM Event ID:      14397 Task Category: (1001) Level:         Warning Keywords:      Classic User:          N/A Computer:      Lync Director FQDN Description: A configured certificate could not be loaded from store. The serial number is attached for reference. Extended Error Code: 0x800B0109 (A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.). Event Xml: http://sch...
Post a Comment
Read more