DTS Password Recovery

  • We recently had an employee leave under bad terms that left refusing to give up the passwords to about 20 DTS packages. Does anyone know how to recover DTS package passwords? Utility??

    I need to do this as soon as possible since some of the connection passwords will expire within 30 days and must be updated.

    Shadar

  • I'd say you've got 30 days to swallow a bitter pill and get chummy with the recently departed employee.

    Then I'd set about setting up standards and procedures to ensure it doesn't happen again.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • There has been no documented way of recovering DTS package passwords, no.

    You might try and place a support call with Microsoft to see if there is something they can do, but certainly they wouldn't release how to break DTS if they do have some method of doing so.

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • There were procedures in place. That's mostly why she was fired. She was making changes on the our system and linked systems without documenting or telling anyone.

    The odds of getting chummy with her are slim and none.

  • Check with your legal department. There may be a legal channel to be able to force her to turn over the passwords or she'll be liable for the damage. People usually start toeing the line when a subpoenia hits.

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply