Post reply

how to generate the script for alluser on database

  • November 13, 2008 at 2:49 am

    #92824

    Good Morning,

    I would like to know, if anyone know's how to generate the create of all users on DB by script (SQL SERVER 2000)

    Thanks,

    Best Regards

  • November 13, 2008 at 3:09 am

    #897951

    Hello,

    I assume you want to grant DB access to Logins that already exist – correct?

    In which case highlight the DB in Enterprise Manager, Select Tools from the Menu Bar, then Generate SQL Script. In the pop-up Window that follows, select the Options tab, and then check the box for Script DB Users and Roles.

    Regards,

    John Marsh

    PS: There is also a checkbox to script the Server Logins if that is also necessary.

    www.sql.lu
    SQL Server Luxembourg User Group

  • November 13, 2008 at 3:25 am

    #897955

    Hello again,

    It seems perfect for me, thanks, obrigado,gracias 🙂

  • November 13, 2008 at 3:29 am

    #897957

    Hello,

    I am glad to hear it was what you needed.

    Best regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • November 13, 2008 at 3:35 am

    #897961

    Hi,

    But i still have one problem, i want to run that script on SS 2005 and when i try i received

    "Password validation failed. The password does not meet Windows policy requirements because it is not complex enough"

    Any ideia?

  • November 13, 2008 at 4:47 am

    #897983

    Hopefully this link will help:

    http://msdn.microsoft.com/en-us/library/ms161959(SQL.90).aspx

    Assuming that is the issue then I found this on an MSDN blog:

    Q: I keep getting messages about my password not being acceptable when creating a new login. How do I fix this?

    A: The error message will usually indicate what the problem is; for example, it will tell you if the password is too short. To find more details about what restrictions are in place for passwords, you can check the policy settings using the secpol.msc tool, as described in a previous answer. You can also disable the policy enforcement for the login, but this is not recommended as it can make that login more vulnerable to a bruce force attack.

    Best regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 6 posts - 1 through 5 (of 5 total)

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