April 13, 2011 at 9:49 pm
Hi,
I transfered a database from one instance(sql 2008) to another instance(sql 2008). Now i want to transfer the users of that database in that instance to the transfered database in another instance. Can some one help me in this please.
April 14, 2011 at 3:43 am
Please do chk the below link.
http://support.microsoft.com/kb/246133
April 15, 2011 at 7:18 am
How did you transfer the DB?
Did you detached and attached or did you restored?
If you used any of those ways to move your DB to another server, then you must know that the database users have been moved along with the DB.
What did not get move was the Logins for those users.
So, just script out the logins on the OLD server, and create them on the New Server.
After that, just fix the orphans users on the database by running sp_change_users_login SP.
EXEC sp_change_users_login 'Update_One', 'MyDBUser', 'MyLogin';
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 15, 2011 at 7:39 am
You can use SSIS Transfer Login Tasks component
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply