Getting an error when saving a schedule to run a weekly report.

Version 1

    Details

     

    When trying to setup a report to run weekly within Heat 20xx the following error is displayed
    Exception: Exception: Error while accessing Report server.
    An attempt has been made to use a delivery extension that is not registered for this report server

     


    Resolution

     

    SSRS needs to be setup for email.

    On the Database Server (or Server set up for SSRS.
    1. All programs > Microsoft SQL Server R2 > Configuration Tools > Reports Service Configuration Manager.  
    2. Email Settings and Enter SMTP Server and Send Address. 
        Note - The Sender Address would usually be a generic email account for your support desk. 
    3. Restart the reporting service