Login accounts

• Dave Nebel

  Grasshopper

  Points: 16

  More actions

  May 27, 2016 at 1:34 pm

  #151566

  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.

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  May 28, 2016 at 5:08 am

  #1881912

  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"