Post reply

migrate logins from SQL 6.5 to SQL 2000

  • September 16, 2009 at 7:59 am

    #209937

    Hi,

    AM trying to find articles on how to migrate logins/users from SQL 6.5 to SQL 2000. I have already migrated the databases using the Upgrade wizard. I received a DB dump, which I restored on a new SQL 6.5 instance and performed the migration. The user database dump did not have the logins. Now, I need to migrate the logins from the source. I tried scripting the syslogins table with the below SQL statement. But, when I run this script, SQL Server 2000 will further encrypt the password. Can some how please guide on how to perform the logins migration

    SELECT

    'EXEC sp_addlogin ''' + name + ''''

    + ', @passw = ''' + password + ''''

    + ', @defdb = ''' + dbname + ''''

    + ', @deflanguage = ''' + language + ''''

    FROM syslogins

    Thanks very much

  • September 16, 2009 at 8:41 am

    #1054499

    I guess, if I run the sp_addlogin along with @encryptopt = 'skip_encryption_old', then the password will not be encrypted. It worked for a test login that I created. I will migrate the rest of the logins and update this forum.

    Does anybody know how to decrypt and view the passwords ?

    Thanks,

  • September 16, 2009 at 8:50 am

    #1054511

    It is well known issue for SS6.5

    Here is a solution:

    http://support.microsoft.com/kb/285025

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

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