Encrypting SSRS subscribed reports

Question

Encrypting SSRS subscribed reports

DSC123

SSChasing Mays

Points: 628
More actions
May 21, 2018 at 7:28 am

#356477

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

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

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

Thom A SSC Guru Points: 99128 More actions · Answer 1

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

DSC123 SSChasing Mays Points: 628 More actions · Answer 2

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 🙁

gregnorris1 Grasshopper Points: 15 More actions · Answer 3

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.

DSC123 SSChasing Mays Points: 628 More actions · Answer 4

Hi Greg,

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

Thank you,
Daz

seantBorner Grasshopper Points: 11 More actions · Answer 5

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.

This reply was modified 2 years, 5 months ago by seantBorner.

MaxBrackett Grasshopper Points: 16 More actions · Answer 6

I'm also needing to do this... currently using a very convoluted way to do it... looking for a better and quicker way to setup... currently, save to a folder in OneDrive, use power automate to move to SharePoint shared folder or to email and encrypt the email (about to build the PA task today).