I added a new TimedSubscription to a report. However when the report ran, it hit an error. The Status text was as follows.
Failure sending mail: The permissions granted to user 'domain\user1' are insufficient for performing this operation.
(assuming domain\user1 was my account)
I have the Content Manager role to the report and its folder. I could run the report interactively with no issues. This particular report does not require any parameters.
The odd thing was this only happened when I selected "Include Report". If I selected only "Include Link" it would be fine.
To troubleshoot, I changed my role to System Administrator in Report Manager and re-tried. The same result was observed. However after I added my user account, domain\user1, to the local Administrators group, the problem went away!
What rights (in SSRS, local server, folder, etc) does a user need to have in order for the e-mail subscription with file inclusion to work?
The systems involved are as follows.
Windows Server 2003 (SP2)
Microsoft SQL Server Standard Edition, 9.00.4053.00
View Complete Post