Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
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

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
    
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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