• I just looked up the original request and it says that there are 3000 users. I agree with the previous statement of IloveSQL that with this number of users who are the domain users you will be MUCH better off granting access to the domain user group, like a global group / groups. Please, read about a difference between Windows logins in SQL Server and SQL Server standard logins. If you implement a Windows Group approach, you will not have to manage those users. If you implement SQL Standard logins you will need to manage 3000 logins when someone comes to your company or if he leaves. The permissions will be very difficult to manage too.

    Is there any way for you to use Windows Authentication?

    Yelena

    Regards,Yelena Varsha