October 6, 2008 at 8:14 am
I have a database in central server & I got the backup of it & restored in my development server. Whenever I do it I have to create my Server login after I make a restore from the backup file.
But, when I perform a mapping of Server login to User login it fails telling the users already exists in the database.
My requirement should be the Server login and database user name be the same.
Is there a way I need not drop the database user again & re-create all logins?
Thanks.
October 6, 2008 at 8:36 am
There is a good article on this site that should help you:
http://www.sqlservercentral.com/articles/Administration/61648/
Kyle
October 6, 2008 at 9:55 am
Specifically, use sp_change_users_login to link the user with the login on the development server.
Greg
October 6, 2008 at 2:05 pm
"sp_change_users_login" procedure worked perfectly fine for me.
Thank you all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply