locked
sql server 2000 Migration RRS feed

  • Question

  • They have lost the passwords for sql logins. SHould I do an upgrade or still try to migrate?

    Alan

    Sunday, February 25, 2018 2:32 AM

All replies

  • Migration to a new version is an upgrade, too; both want change anything about the unknown passwords.

    As already suggested by Phil in your other thread sql server 2000 you can reset the password for a SQL login.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Sunday, February 25, 2018 5:37 AM
  • We are concerned about changing passwords because we don't know what apps might be hard coded.

    Alan

    Sunday, February 25, 2018 5:59 AM
  • Then you have an issue where we can't help; it's not possible to get the password from existing linked server/logins.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Sunday, February 25, 2018 6:43 AM
  • Yeah I am at a complete loss. This guy is saying go ahead with the migration. But if we did an upgrade we wouldn't have any issues with passwords. I just don't know what to say or do. I know that a migration is going to be a complete catastrophe. Any suggestions???

    Alan

    Sunday, February 25, 2018 10:51 AM
  • On a in-place migration you don't need to re-enter credentials/password for linked server, they will work after migration as before.

    You only need as SQL SysAdmin account to perform the migration.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Hannah Yu Thursday, March 1, 2018 9:40 AM
    Sunday, February 25, 2018 1:10 PM