SSRS - Report Server Question: When adding a subscription, there is no option to select "Email" as the delivery method

  • I added an email account, sent an test email, YES it works ( i mean I received an email ) 

    Next Question:
    See attached. Why is there no option for selecting email as the delivery method ?

  • Sorry, mw112009, but again, Google... SSRS Enable Send subscription by email

    I don't mean to be rude, but please try solving your problem first, rather than coming straight to the forums at the first hurdle. After I searched that the very first thing I got was MSDN, which starts by stating:

    Reporting Services includes an e-mail delivery extension so that you can distribute reports through e-mail. Depending on how you define the e-mail subscription, a delivery might consist of a notification, link, attachment, or embedded report. The e-mail delivery extension works with your existing mail server technology. The mail server must be an SMTP server or forwarder. The report server connects to an SMTP server through Collaboration Data Objects (CDO) libraries (cdosys.dll) that are provided by the operating system.

    The report server e-mail delivery extension is not configured by default. You must use the Reporting Services Configuration Manager to minimally configure the extension. To set advanced properties, you must edit the RSReportServer.config file. If you cannot configure the report server to use this extension, you can deliver reports to a shared folder instead. For more information, see File Share Delivery in Reporting Services.
    Emphasis mine.

    If you always come straight to the forums, rather than trying to solve the problem yourself, you're not going to end up getting the help you need when you really need it.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Thom A - Friday, January 20, 2017 1:05 PM

    Sorry, mw112009, but again, Google... SSRS Enable Send subscription by email

    I don't mean to be rude, but please try solving your problem first, rather than coming straight to the forums at the first hurdle. After I searched that the very first thing I got was MSDN, which starts by stating:

    Reporting Services includes an e-mail delivery extension so that you can distribute reports through e-mail. Depending on how you define the e-mail subscription, a delivery might consist of a notification, link, attachment, or embedded report. The e-mail delivery extension works with your existing mail server technology. The mail server must be an SMTP server or forwarder. The report server connects to an SMTP server through Collaboration Data Objects (CDO) libraries (cdosys.dll) that are provided by the operating system.

    The report server e-mail delivery extension is not configured by default. You must use the Reporting Services Configuration Manager to minimally configure the extension. To set advanced properties, you must edit the RSReportServer.config file. If you cannot configure the report server to use this extension, you can deliver reports to a shared folder instead. For more information, see File Share Delivery in Reporting Services.

    Emphasis mine.

    If you always come straight to the forums, rather than trying to solve the problem yourself, you're not going to end up getting the help you need when you really need it.

    OK, so how do I get to this file   (RSreportserver.config) ?
    Where is this file located ?

  • mw112009 - Tuesday, January 24, 2017 2:49 PM

    OK, so how do I get to this file   (RSreportserver.config) ?
    Where is this file located ?

    It depends on your install location. For example for my 2016 Dev instance: C:\Program Files\Microsoft SQL Server\MSRS13.SQL2016DEV\Reporting Services\ReportServer

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Hi mw112009,

    Please try to go to "Reporting Services Configuration Manager". Then go to "Email Settings". Type your SMTP Server and Sender Address.

    The Email option for delivery method should be available now after you have done this.

    Best Regards,
    Ricky

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

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