• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

AD deleted user, still setup to run reports in SQL Reporting Services, generating mail errors flooding inbox

getting following email flooding inbox

test23b@#####.## on <date>
 the e-mail account does not exist at the origination this message was sent to. check the email address or contact the recipent directly to find out the correct address
  <SERVER #5.1.1>

i noticed the account an remembered this account had been setup to run automated reports in SQL Server Reporting Services.

the user has since been deleted, and we've been getting errors in event log that made no sense until now.

how can i login to the sql server reporting service and stop anything associated with this user
  • 2
1 Solution
You need to log in as anyone who has Admin rights in SSRS. This is usually the account you installed this with. You can then go into the options and view all subscriptions.

Faiga DiegelCommented:
check each email subscription of each report.
funnymanmikeAuthor Commented:

are you talking about the web reporting page? because i have admin rights but cannot view any other subscriptions besides my own.
funnymanmikeAuthor Commented:

found where you were talking about, took me some browsing to find. this.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now