Solved

SQL Reporting Services - Able to password protect reports?

Posted on 2009-04-07
3
1,508 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:
udaya kumar laligondla 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

808 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