Monday, March 12, 2012

migrate a local SQL user account

whats the simplest way to migrate a user account from a master development SQL server to local development sql servers and also to a production server?

we can recreate the SQL account everywhere, but if we take a backup from one machine and restore to another, we loose access because the accounts arent truly the same account.Very few info can be found in sql books online.
You need to read Microsoft Knowledge Base Article - 246133
check out this link
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q246133|||thanks for the article...i need to run the process that keeps the SID intact.

somehow i new the was no copy/paste solution... :-(

No comments:

Post a Comment