Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Location
    india
    Posts
    41

    Unanswered: script for login transfer from one phy server to another

    Hi,

    Do you have any idea about the procedure for transferring the logins and password from source server to the destination server.

    scenario is as follows

    serv - A wanto transfer to ms sql 2000 server - B
    running on 6.5 --------------------------------------> will be sql2k
    (Old server) (new server)

    will appriciate if any weblink containg the check list.

    with best regards

    ranjan

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I have a script that generates SQL for recreating logins, user, roles, and permissions on SQL 2000 databases. It may run on your 6.5 database.
    It will not, however, restore passwords, and I'm not sure you can do this.

    Have you thought about running the upgrade on your 6.5 databases (or a copy of them)? It's been a while, but I think this retains the old passwords.

    blindman

  3. #3
    Join Date
    Aug 2002
    Location
    india
    Posts
    41
    Thanx for reply,

    Detail of my upgradation plan -

    - I am planning to upgrade my db server (mssql-6.5) to server
    (mssql2k) on the same machine.

    - I have prepared the checklist for that , Only thing I want is a script
    which will take care of transferring my ( login name & passoword)
    from 6.5 server to 2000 server.

    - will appriciate if you can help me in writting the script or foreward a
    readymade script.



    thanx regards

    Ranjan

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Sorry, but I don't have a script for that. Are you sure that the upgrade process won't do this?
    As a matter of fact, I think Microsoft changed its encryption algorythm between versions 6.5 and 2000, so even if you copied the encrypted value to the new server it might not recognize your password. If you are looking for a method of decrypting the password, I don't have one but I know it has been cracked (the algorythm was not very strong). You can probably find code for decrypting it on the web.

    blindman

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to this KBA to accomplish the task.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •