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