Restoring a sql db to another server

  • HI. I am setting up a new sql server and migrating my sql db's to the server. When I do the restore to the new server from the backup, I see the database and it's users. But those users exist as logins on the new server.How do I get them in as logins and do I have to rekey in every user's sql password? By the way, for this particular db, the authentication is sql server userid/password. I am hoping in the restore, the users came over with the password.

    Thanks so much,

    Juanita

  • I use the steps outlined here:

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

  • One thing to note in the following step:

    "The scripts in the following methods create two stored procedures that are named the sp_hexadecimal stored procedure and the sp_help_revlogin stored procedure in your master database."

    When you run the script, the default database for a SQL login and any server roles that user have are not transferred. If this is problem, you may need to modify the script. I've run into this issue a few times.

    Thanks,

    Eric

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

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