Solved

SQL Reporting Services - Able to password protect reports?

Posted on 2009-04-07
3
1,566 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

710 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