May 22, 2006 at 2:46 pm
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
May 24, 2006 at 4:34 am
Add them to a Windows NT / Security group. Add the group as a Login. Assign privileges to the group.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply