SSRS Subscription Error: SQL Server Agent was unable to start

When I tried to start SSRS subscription to send weekly reports by e-mail where the prerequisites for SSRS subscription is to be sure that SQL Server Agent is working,so that I opened SQL Server Management Studio to check SQL Server Agent status but unfortunately it stopped !

sqlagent

It’s ease of cake  to start SQL Server Agent by right click and select start ! but In my case when I tried to start it I got the following information dialog

unabletostartagent

Cause:

Based on the additional information that mentioned in information dialog, the SQL Server Agent was unable to start because of Service Logon Failureso that this problem might occur because of changing the password of service account that used to run SQL Server Agent service.

Solution:

To solve this issue you should reset SQL Server Agent service account log on information by following the bit steps below:

  • Type in Run Dialog services.msc

services.msc

  • Find SQL Server Agent (Your instance name) from services list.
  • Right Click > Select Properties.

Services

  • Navigate to Log On Tab > Update the current service account password  as shown belowLogOnProerties
    • you can also change your service account by clicking Browse and select the new account).
  • Click OK > Start SQL Server Agent.

startserveragent

  • SQL Server Agent should now been started.

startedserveragent

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s