Create windows users - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create windows users

Author

Topic

electra109
Starting Member

4 Posts

Posted - 2011-09-07 : 07:34:21

I need to create 200 sql users with windows authentication

Adding the database they are allowed to access

I want a script to run so it users a list froma spreadsheet to create each user

Could this be done

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2011-09-07 : 07:58:36

You could use SSIS to import the values into a temp table then insert into your existing users table. I have just used this to import data into SQL server table. Instructions I used are here:

http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm

G

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources