Max count of logins

Hi!
SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
(Don't know the exactly number yet, but the limitation is there...)
Did anyone know if SQL Server 2005 still has a limitation regarding the
number of possible SQL Server logins?
Thanks in advance.
Thomas
www.sqlscripter.com
Hi
Any that is a problem?
What is your scenario that you need so many logins?
How do you manage such a number?
Are you not using NT/AD groups and giving the groups access to he DB?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thomas" wrote:

> Hi!
> SQL 2000 has a limitation of approx. ~ 16000 SQL Server logins.
> (Don't know the exactly number yet, but the limitation is there...)
> Did anyone know if SQL Server 2005 still has a limitation regarding the
> number of possible SQL Server logins?
> Thanks in advance.
> Thomas
> www.sqlscripter.com
>
|||Thanks for your feedback.
We need that for a Self Service system, i know that using NT (groups) we
will not have these problems ...
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Any that is a problem?
> What is your scenario that you need so many logins?
> How do you manage such a number?
> Are you not using NT/AD groups and giving the groups access to he DB?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Thomas" wrote: