Home Forums SQL Server 2012 SQL 2012 - General SSRS - Report Server Question: When adding a subscription, there is no option to select "Email" as the delivery method RE: SSRS - Report Server Question: When adding a subscription, there is no option to select "Email" as the delivery method

  • 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 ?