Solved

SQL Reporting Services - Able to password protect reports?

Posted on 2009-04-07
3
1,635 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

628 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