Tuesday, March 27, 2012

DTS Protection

I'm trying to protect a package... using an owner password.
After I create an owner password and generate a dts command line from
DTSRunUI... it puts the package password in the string.
Basically if someone goes into the job and looks at this line they have the password to open the package...

DTSRun /S "svr-eqanalysis" /N "OrgExtract Rename" /M "password" /G "{2E2B6F07-0E56-4212-A894-B85A4EAA6C8C}" /W "0" /E

We can not remove the builtin administrators group from the machine
therefore system admins that want to poke around into our work can do so...
any suggestions.....

thanks,

jonathanRight click on the package, and select schedule. SQL Server automatically encrypts the whole command line for you. You may have to recover this from the job itself.|||Perfect.... !!!
thank you.....
jonathan|||Mcrowley
How would one stop a person from messing with the sql server agent... under the same circumstances...
stopping from someone changing a particular job...
more then one dba or system admin has a job
you want to secure just your job from others...
possible... ?

No comments:

Post a Comment