Solved

SQL Reporting Services - Able to password protect reports?

Posted on 2009-04-07
3
1,470 Views
Last Modified: 2012-05-06
I currently have a few reports that have bank information in. I want to be able to password protect the ability of opening/running these reports. Is there a way to do this? I have researched but I haven't found anything that gives an idea on how to accomplish this.

Also, is there a way to password protect an excel file that you export.
0
Comment
Question by:GLIanimal
3 Comments
 
LVL 12

Accepted Solution

by:
udayakumarlm earned 500 total points
ID: 24088186
you have to create your own rendering extentions use
http://msdn.microsoft.com/en-us/library/ms154606(SQL.90).aspx
http://www.microsoft.com/Sqlserver/2005/en/us/reporting-services.aspx
may help to create an extention
0
 
LVL 5

Expert Comment

by:TheVeee
ID: 24088241
You can add a password manually to the spreadsheet by the following:
http://www.online-tech-tips.com/ms-office-tips/the-password-you-can-always-remember/

Dont know what your process is of "making" the spreadsheet so if its a automated way you will need get excel object and then assign the password.

Another way is to place it in a secured directory so only user authorized to access that directory can even get to the spread sheet.

0
 

Author Closing Comment

by:GLIanimal
ID: 31567546
Used the reporting manager to limit access of the report to certain domain users only.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question