February 10, 2004 at 1:52 am
I have a situation where a Developer created a DTS, put an owner password and an user password & Finally forgot both.
Developer requested me, if I could retrieve / reset the password.
Even after spending a lot of time with BOL / Internet on the same topic, I could not solve this problem.
Is Anyone aware of any method to RESET / CHANGE a DTS's OWNER / USER passwords ?
And
Why can't "sysadmin" members reset a password of a DTS without knowing the original password? (I know they can reset login password without knowing password !! )
-- Amit
February 10, 2004 at 7:48 am
I know of no tool at this point that can hack the DTS encryption or these. However right click the package and try one of the previous versions (DTS has a versioning system built in) to see if maybe he saved a version without these in place but complete otherwise. That is your best bet.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply