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.
Whar are methods 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 !! )
-- Amithttp://www.sqldts.com/default.aspx?212|||does reset owner.
I want to reset package owner password.
As owner password is not available with a sa, DTS Designer does not allow "s
a" to edit package / open package / schedule package.
-- amit
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment