Hi

I'm about to move some databases between 2 SQL Server 2005 installations. I
plan to copy the databases manually, and then to move logins I plan to follow
the steps outlined in KB 918992 "How to tranfer the logins and the passwords
between instances of SQL Server 2005".
By doing this, do I have to perform aditional steps for users to have the
same rights on the databases on the new server? As far as I can recall this
is stored in the databases, so by following the steps in the article the
target server will be the same as the source when it comes to user rights in
the database., correct?

If all the logins are successfully created by following the procedure you
point to, the logins will connect with the users in the databases and the
rights will be retained.

If any of the logins have server rights in addition to database rights,
those will need to be scripted and reapplied. Rights such as VIEW SYSTEM
STATE or membership in server roles such as serveradmin, etc.

RLF


"MRWildiac" <MRWildiac (AT) discussions (DOT) microsoft.com> wrote