3

Is it possible to set up an SSRS e-mail subscription, with an attachment, that is encrypted?

POST ANSWER-ACCEPT UPDATE: Does the SMTPUseSSL switch in the RSReportServer.config file help me at all?

ONE MORE UPDATE: No, the SMTPUseSSL switch does not get me there. I have validated the answer below here:

The default e-mail delivery extension does not provide support for digitally signing or encrypting outgoing mail messages.

  • Try this link databasepotential.com Actually i got some errors while using the tool but no one is responding to the emails from this vendor. Thanks Mahesh – user25220 Jun 21 '13 at 5:11
3

Not out of the box as far as I am aware, and if you need to distribute reports to external parties this is a bad idea as they will all have to install third party encryption software (incurring licensing and support costs). It will also put your help desk people into the job of babysitting all the users as they forget their keys.

You're much better off providing a secure portal (this can be done with Sharepoint if you have this) and emailing out links to the reports.

  • Unfortunately, I have a number of constraints. We are not on the latest version of SharePoint, in which I could distribute straight to SharePoint and remove the need for the e-mails. The distribution is, indeed, all internal but our policies dictate that the e-mails/attachments be encrypted. I'm not optimistic that this is possible, but I figured I'd float the question. :) – JHFB May 16 '12 at 15:49
  • 1
    The other option would be to put them on a file share and with AD managed security. – jgardner04 May 16 '12 at 16:07
  • +1, @jgardner04 - that's actually what we currently do. :) I am exploring other options. – JHFB May 16 '12 at 17:35
  • The encryption is a tough requirement. – jgardner04 May 16 '12 at 20:12
  • 1
    You're better off serving them through a portal than trying to roll out encrypted email infrastructure. That gets you into babysitting everyone's encryption keys, and when they lose the keys they lose the encrypted reports, so you've got to stash plaintext copies of them somewhere as well. – ConcernedOfTunbridgeWells May 16 '12 at 20:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.