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
LVL 5
funnymanmikeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

St3veMaxCommented:
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.

HTH
0
Faiga DiegelSr Database EngineerCommented:
check each email subscription of each report.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
funnymanmikeAuthor Commented:
St3veMax

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

found where you were talking about, took me some browsing to find. this.
here.gif
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.