Maximum number of logins?

SQL Server 2000 Enterprise SP3a
Is there a limit on the number of logins that can be created?
Probably 32K but I can't find any documentation on this. More than likely
you will run into other problems before you run out of logins. If you need
that many you really should be looking at using Windows Logins anyway.
Andrew J. Kelly SQL MVP
"DJ" <DJ@.discussions.microsoft.com> wrote in message
news:DA6634DC-058F-410E-AB81-7D8C20EF238F@.microsoft.com...
> SQL Server 2000 Enterprise SP3a
> Is there a limit on the number of logins that can be created?
|||We hit the limit at 16k. They lifted it in SQL 2005.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ulBS8xtIGHA.344@.TK2MSFTNGP11.phx.gbl...
Probably 32K but I can't find any documentation on this. More than likely
you will run into other problems before you run out of logins. If you need
that many you really should be looking at using Windows Logins anyway.
Andrew J. Kelly SQL MVP
"DJ" <DJ@.discussions.microsoft.com> wrote in message
news:DA6634DC-058F-410E-AB81-7D8C20EF238F@.microsoft.com...
> SQL Server 2000 Enterprise SP3a
> Is there a limit on the number of logins that can be created?
|||Maximum user connection is, 32767 with 37KB of memory per user. Our server
settings is set for 1000 connection as per business requirement. You can
change that using sp_configure in Advanced option, use reconfigure after that
and it will take effect only after a reboot.
"DJ" wrote:

> SQL Server 2000 Enterprise SP3a
> Is there a limit on the number of logins that can be created?
|||The maximum user connection is, 32767 with 37K memory for each connection.
Ours is 1000 depending on business requirement. You can change the number of
connection using sp_configure advanced option enabled and reconfigure. Do a
restart to make the change into effect.
Thanks,
Sree
"DJ" wrote:

> SQL Server 2000 Enterprise SP3a
> Is there a limit on the number of logins that can be created?
|||There's a difference between logins and connections. The OP asked about
logins.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:0BCA5411-F5A6-4E34-9BC9-B330E687943A@.microsoft.com...
The maximum user connection is, 32767 with 37K memory for each connection.
Ours is 1000 depending on business requirement. You can change the number of
connection using sp_configure advanced option enabled and reconfigure. Do a
restart to make the change into effect.
Thanks,
Sree
"DJ" wrote:

> SQL Server 2000 Enterprise SP3a
> Is there a limit on the number of logins that can be created?
||| oopsss sorry...
Breaking my head i feel, its the maximum number of rows that a table can
have. i.e for syslogins table. Because its where the login details are kept.
And the maximum number of rows for a table in turn is "Limited by available
storage". So that might be the answer, iam not sure if there is any fixed
limit for maximum number of logins...
Thanks,
Sree
"Tom Moreau" wrote:

> There's a difference between logins and connections. The OP asked about
> logins.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
> news:0BCA5411-F5A6-4E34-9BC9-B330E687943A@.microsoft.com...
> The maximum user connection is, 32767 with 37K memory for each connection.
> Ours is 1000 depending on business requirement. You can change the number of
> connection using sp_configure advanced option enabled and reconfigure. Do a
> restart to make the change into effect.
> Thanks,
> Sree
> "DJ" wrote:
>
>
|||We hit the same limitation - thanx for verifying this. I couldn't find a doc
on it.
-DJ
"Tom Moreau" wrote:

> We hit the limit at 16k. They lifted it in SQL 2005.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:ulBS8xtIGHA.344@.TK2MSFTNGP11.phx.gbl...
> Probably 32K but I can't find any documentation on this. More than likely
> you will run into other problems before you run out of logins. If you need
> that many you really should be looking at using Windows Logins anyway.
> --
> Andrew J. Kelly SQL MVP
>
> "DJ" <DJ@.discussions.microsoft.com> wrote in message
> news:DA6634DC-058F-410E-AB81-7D8C20EF238F@.microsoft.com...
>
>