Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Reporting Services Permissions

Author  Topic 

jneff02
Starting Member

10 Posts

Posted - 2009-05-28 : 10:43:47
Our employee who took care of SQL Reports is now gone. I disabled his windows AD account and then the automated reports stopped sending and now users can't view reports through the SQL Server Reporting Services web interface. It gives them a logon failed error, even though they logged into the web interface with their own AD credentials. I hope that make sense. I would like to know what is happening and how to fix it.

Thank you for any help in advance!

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2009-05-28 : 11:49:02
subscriptions are usually created by user and if you disable a user, subscriptions will also fail. set new subscriptions under new account in order for automated sending of reports.

each report in Report Manager has administrator right assigned. see and edit administrator group, otherwise check the security for each of the report is permission are still set.

best
Go to Top of Page
   

- Advertisement -