November 19, 2008 at 2:54 pm
There are two reports that are setup to notify the sales people about their aging accounts. One is setup by Sales Rep and the other is by Sales Territory. The woman in accounting, DWilliams, is the owner of the subscriptions that run automatically every Monday morning. DWilliams was terminated over a month ago, but no one in Accounting was monitoring the reports going out. Now that I am looking into it, I see something odd. The Aging by Sales, owned by DWilliams, is still running fine. The Aging by Territory, owned by DWilliams, is not running and has the following error.
"Failure sending mail: The permissions granted to user 'COMPANY\DWilliams' are insufficient for performing this operation."
So we have two reports in one folder, owned by the same person who no longer works here and the reports run at the same time, but one works and one has permission issues. I would expect both of them to have permission issues since she no longer works here. Does anyone have any idea why this is happening? Why aren't both working or both failing?
November 24, 2008 at 4:56 am
You can see that it has been created by DWilliams. But when she created the subscription, one might have her username and password assigned during setup and another will have your general username and password which you should use. Some times it happens that user you use for setup of subscription doesnt have permission to some folder etc so developer can give own username and password to work. Obviously it is not the right way as we have to change our password after some time. I would think that might be the issue. Check the type of subscription and username used into that subscription.
November 24, 2008 at 8:25 am
I have already gone and changed all of the subscriptions to a default user for the accounting group so I can't go looking at the owership of all those reports. But I can say that I am the only person with any knowledge on how to administrate the Reporting Services, so no one else could have used a back door, And she was the only one who was responsible for these reports. I was just curious.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply