creating a dev server with same security

• rightfield

  SSCrazy

  Points: 2418

  More actions

  April 17, 2008 at 8:26 pm

  #93233

  Hi experts,

  We are/have created a dev server and want to apply the same security and logins to everything. It will be the same domain, Active Directory, MS SQL Server 2000, same filegroup structure, same databases, same everything (we hope), just on a different server (sql_prod versus sql_dev). Where do I start looking to know how to duplicate the security and logins? Is there something in DTS? What are the right questions?

  Warm regards,

  hopi

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 20, 2008 at 9:02 pm

  #804742

  You may try this one in the following link:

  http://www.sqlservercentral.com/articles/Administering/migratingloginstoanotherserver/1140/