Encrypting SSRS subscribed reports

  • Hi everyone,

    Due to GDPR coming in, I've been told I need to send encrypted PDF's via the Reports Scheduler - I've had a look online and can't see a solution which is cost effective.  Has anyone figured out a simple way to password protect subscribed reports please?

    Thank you
    Daz

  • DSC123 - Monday, May 21, 2018 7:28 AM

    Hi everyone,

    Due to GDPR coming in, I've been told I need to send encrypted PDF's via the Reports Scheduler - I've had a look online and can't see a solution which is cost effective.  Has anyone figured out a simple way to password protect subscribed reports please?

    Thank you
    Daz

    I don't think there is an out of the box solution, no. If you do need to do something that encrypts the PDF, you'll probably going to need to purchase something and from your post that sounds like what you've looked at (and seen it's not cheap).

    I assume this means that your emails, from SSRS and/or your mail server, aren't being sent via TLS and hence the requirement? Out of interest, what is the specific reason you're being told they need to be encrypted? I realise it's in relation to GDPR, but i mean what specifically about the document causes this change in process?

    Thom~

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

  • Hi Thom,

    Thanks for you reply - our reports have customer identifiable information sent directly to a broker, customer name, postcode.  They require this otherwise the reports are useless to them.
    I'm checking with our IT guy now and he doesn't seem to think our emails are encrypted 🙁

  • We had requirement to password protect a couple of our SSRS subscriptions in the past.  Our approach though not so graceful was workable. We setup an SSRS subscription to save the report to a shared folder.  Then we scheduled an SSIS package to check that folder for the file, compress and password protect it before attaching the compressed version of file to an email for send.  We created a small config table in source system to store email address, file name etc for the SSIS package to use.

  • Hi Greg,

    Many thanks for replying - that seems like a good idea!  I'll explore it today.

    Thank you,
    Daz

  • I know it's been 4 years but having the same issue with subscriptions containing necessary PII for job sites. Please let me know if there are better ways to do this now as I am not a regular SQL user. I am on the security side these days and found way too many reports containing PII, to the point that we stopped SSRS subscription altogether until we can find a better way to email with reports encrypted.

Viewing 6 posts - 1 through 6 (of 6 total)

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