Post reply

Can not send SSRS reports by email

  • March 12, 2012 at 11:21 am

    #254542

    In a Sharepoint 2007 with SQL 2008 that has SSRS configured in Sharepoint Integrated Mode, the reports run correctly from the Sharepoint site but does not email out the reports. The error message below is displayed in the mange subscriptions page for a SSRS report.

    Failure sending mail: The permissions granted to user 'MyNetwork\User1' are insufficient for performing this operation.Mail will not be resent.

    I am logged in as MyNetwork\User2 and I cannot see any reference to User1 in the SSRS .Config files. What other locations should be checked for this account setting to be able to change it to MyNetwork\SSRSAccount?

  • March 12, 2012 at 11:36 am

    #1458054

    Hi Mark,

    Not sure if it applies as I don't use SSRS in Sharepoint mode, but what's listed on the Email Settings page of the Reporting Service Configuration Manager? (Shortuct should be somewhere in the SQL Server program group on the Start menu).

    Cheers

  • March 13, 2012 at 4:09 am

    #1458373

    Thanks, I had checked that and the SSRS .config files that the configuration information is stored in.

  • March 13, 2012 at 5:12 am

    #1458393

    Ok, see if the information here is any use to you:

    http://technet.microsoft.com/en-us/library/ms345234.aspx

    There's also a link on that page that goes into more detail on the structure of the RSReportServer.config file.

    Thanks

  • March 14, 2012 at 3:55 am

    #1459054

    This is now working. The problem was due to user1 account setup the subscription and now the permissions have been removed from this account. It just required a new subscriptions to be created using account User2.

  • March 14, 2012 at 5:11 am

    #1459089

    Cool, glad you found the solution!

    Gaz

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply