Restoring a sql db to another server

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  October 26, 2007 at 9:32 am

  #180705

  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

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  October 26, 2007 at 9:39 am

  #745789

  I use the steps outlined here:

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

• Strommy

  SSCrazy

  Points: 2386

  More actions

  October 26, 2007 at 11:32 am

  #745844

  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