October 26, 2007 at 9:32 am
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
October 26, 2007 at 9:39 am
I use the steps outlined here:
October 26, 2007 at 11:32 am
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