Your organization uses Active Directory, and only Windows Authentication is used on various server systems running SQL Server. An instance and a database named Accounting are on an older server named Mercury. A new server named Saturn has just been installed. The accounting instance and database should be moved from Mercury to Saturn. What security changes or tasks might be needed to accomplish this data base relocation?
Answer: – Once Saturn is part of the Active Directory network, the existing Windows users will have access to Saturn.
(Active Directory will authenticate Windows users, and via SQL Server Windows authentication, existing users will have access to Saturn. If the instance and database are relocated properly, then the users will have the same rights as they had on Mercury.)