Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Maximum number of logins?SQL Server 2000 Enterprise SP3a Is there a limit on the number of logins that can be created?
Post Follow-up to this message
Re: Maximum number of logins?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?
Post Follow-up to this message Re: Maximum number of logins?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?
Post Follow-up to this message RE: Maximum number of logins?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 tha t 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?
Post Follow-up to this message RE: Maximum number of logins?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?
Post Follow-up to this message Re: Maximum number of logins?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?
Post Follow-up to this message Re: Maximum number of logins?:) 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: > > >
Post Follow-up to this message Re: Maximum number of logins?We hit the same limitation - thanx for verifying this. I couldn't find a do c 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 nee d > 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... > > >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
