SQL Reporting Services - Able to password protect reports?

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.
GLIanimalAsked:
Who is Participating?
 
udaya kumar laligondlaTechnical LeadCommented:
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
 
TheVeeeCommented:
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
 
GLIanimalAuthor Commented:
Used the reporting manager to limit access of the report to certain domain users only.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.