• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • 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 DiegelSr Database EngineerCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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