Results 1 to 4 of 4

Thread: DTS Protection

  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Question Unanswered: 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,

    jonathan

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Right 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.

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    Perfect..... !!!
    thank you......
    jonathan

  4. #4
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    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.... ???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •