Adding 60 new developers

• Eric Peterson

  Hall of Fame

  Points: 3192

  More actions

  May 22, 2006 at 2:46 pm

  #117727

  All

  I am setting up a new development environment.   I have 60 developers who all have windows accounts on the local domain.   I have 45 developers who need access to the development SQL Server instance.  

  Is there an easy way to drop in or bulk select them from a list without going thru the process one at a time?

  I know that I can use sp_addlogin, but I am not sure if I can do that with windows domain accounts....but there is the new Create login so If i can export the list I can generate a list or export a list I can quickly transform that inot a series of : CREATE LOGIN [ADVWORKS\fogisu] FROM WINDOWS 

  Thanks in advance

  Eric Peterson

   

   

   

   

• jfmccabe

  SSCrazy

  Points: 2527

  More actions

  May 24, 2006 at 4:34 am

  #639707

  Add them to a Windows NT / Security group. Add the group as a Login. Assign privileges to the group.