Link to home
Start Free TrialLog in
Avatar of funnymanmike
funnymanmikeFlag for Canada

asked on

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
Avatar of St3veMax
St3veMax
Flag of United Kingdom of Great Britain and Northern Ireland image

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
ASKER CERTIFIED SOLUTION
Avatar of Faiga Diegel
Faiga Diegel
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of funnymanmike

ASKER

St3veMax

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

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