Login accounts

  • I have an old application that is using a SQL 2000 database. We are in the process of moving the database from SQL 2000 to SQL 2008 R2. I have the accounts but I do not have the passwords that the application uses and there is not a configuration file that I can change to password.

    Does anyone have a process that works to do the following:

    - Migrate the account and password to a different server

    - Decrypt the password

    Thanks for all the help.

  • If they are SQL logins Microsoft has a support article that has you covered.

    How to transfer logins and passwords between instances of SQL Server

    https://support.microsoft.com/en-us/kb/246133

    Joie Andrew
    "Since 1982"

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

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