Post reply

Bulk Login Creation Script

  • December 15, 2011 at 7:54 am

    #253481

    Please Let me know if anyone have Bulk Login Creation Script.

    Requirement: Create SQL and Windows Logins in Bulk at a time and assign them to database roles within a database at same time.

  • December 15, 2011 at 8:08 am

    #1421980

    i've seen and create scripts to transfer logins from one server to another ...search for sp_help_revlogin...i believe there are different versions depending on whether you are 2005 vs 2008, get it directly from Microsoft to be sure.

    now if you are looking for something that queries active directory, and creates logins, you don't wnat to bulk copy users, you want to create users based on the groups in active directory that should have access...that's going to require some biz decision that a script couldn't realy assume, i think.

    can you clarify what you are looking for?

    what do you expect the script to do?

    if my active directly has 50 users, and 20+ groups, with everything from MyDomain\AuthenticatedUsers to ones i created like myDomain\Developers, what would you expect the script to do with them?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply