Bulk User Creation

• Brad Townsend

  Newbie

  Points: 1

  More actions

  April 21, 2005 at 8:25 am

  #166588

  Does anyone know of a way (scripts or otherwise) to automate the creation of user accounts with sql authentication in bulk. I am having to learn SQL Server 2000 as I go and my current task is creating SQL logins for all the users accessing the applications that use the database. The software vendor of the application requires me to use SQL authentication instead of AD authentication. I have somewhere between 200 and 300 accounts to create and doing them one at a time is time consuming to say the least.

  Any help would be appreciated.

  ---

  Brad Townsend
  

• Daniel Worby

  SSC Enthusiast

  Points: 144

  More actions

  April 22, 2005 at 12:55 am

  #554264

  Brad,

  you can use the sp_adduser, sp_grantdbaccess and sp_addrolemember system stored procs to create the accounts and set up their access.