|
Home > Archive > MS SQL Server > January 2006 > Maximum number of logins?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Maximum number of logins?
|
|
|
| SQL Server 2000 Enterprise SP3a
Is there a limit on the number of logins that can be created?
| |
| Andrew J. Kelly 2006-01-26, 8:23 pm |
| 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@microso
ft.com...
> SQL Server 2000 Enterprise SP3a
>
> Is there a limit on the number of logins that can be created?
| |
| Tom Moreau 2006-01-26, 8:23 pm |
| 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@shadh
awk.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@microso
ft.com...
> SQL Server 2000 Enterprise SP3a
>
> Is there a limit on the number of logins that can be created?
| |
| Sreejith G 2006-01-27, 3:23 am |
| 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?
| |
| Sreejith G 2006-01-27, 3:23 am |
| 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?
| |
| Tom Moreau 2006-01-27, 7:23 am |
| 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@discussion
s.microsoft.com> wrote in message
news:0BCA5411-F5A6-4E34-9BC9- B330E687943A@microso
ft.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?
| |
| Sreejith G 2006-01-27, 7:23 am |
| :) 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@discussion
s.microsoft.com> wrote in message
> news:0BCA5411-F5A6-4E34-9BC9- B330E687943A@microso
ft.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@shadh
awk.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@microso
ft.com...
>
>
>
|
|
|
|
|