Link to home
Start Free TrialLog in
Avatar of ibrahim A
ibrahim AFlag for Kuwait

asked on

securing Excel files with ADRMS

Hi All,

  I have SQL 2008 Database, I will be using ms excel 2007 or 2010 to access the sql analysis services using excel  Data tab, I want to use RMS to keep some security in theses files ex, prevent printing, etc, what is the best way to publish the excel file and keeping the security that I need.

my target: user will access sql database using excel but no printing, etc.

please advise
ASKER CERTIFIED SOLUTION
Avatar of Marten Rune
Marten Rune
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ibrahim A

ASKER

I know but I want a way to restrict them from printing .
RMS should do it to my knowledge. Note that it's not included in standard CALS. You need additional licensing.

//Marten
I do have the license, i need to know what is the best solution to protect the excel connectivity to sql  server
Many different users, a share with rights for a AD group
Just for yourself, EFS encrypted folder

To prevent many users from printing it:
ADRMS, it wont stop users from using a cellphone camera, but still, they will be aware that they are breaking the rules.

Other questions, or is this to your satisfaction?