Number of SQL Server logins

Is there a limit on how many SQL logins can be created on an instance? If
so, where is this documented? Thanks in advance.
OscarNumber of users per database = 16,379
Number of roles per database = 16,367
Number of concurrent connections = 32,767
However, if you are approaching any of these limits, your design will
probably raise quite a few eyebrows...
http://www.aspfaq.com/
(Reverse address to reply.)
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:4159DD0F-0B77-4783-8AEA-A779E3138700@.microsoft.com...
> Is there a limit on how many SQL logins can be created on an instance? If
> so, where is this documented? Thanks in advance.
> Oscar|||Hi
Can't find documentation, but master.dbo.syslogins does not use a counter.
Good so far. Limitation here is number of unique combinations of charaters
that fit into "name" which is nvarchar(128)
In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the
limit per database.
So, it looks like only a per DB limit. Think it is time for me to do a bit
of an experiment.
Regards
Mike
"Oscar" wrote:

> Is there a limit on how many SQL logins can be created on an instance? If
> so, where is this documented? Thanks in advance.
> Oscar|||I compiled this list from a variety of sources, but IIRC, they were all
official:
http://www.aspfaq.com/2345
So I think there might be an enforced limit on users per database...
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:257A5B67-9708-4FA0-B58C-897000078781@.microsoft.com...[vbcol=seagreen]
> Hi
> Can't find documentation, but master.dbo.syslogins does not use a counter.
> Good so far. Limitation here is number of unique combinations of charaters
> that fit into "name" which is nvarchar(128)
> In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the
> limit per database.
> So, it looks like only a per DB limit. Think it is time for me to do a bit
> of an experiment.
> Regards
> Mike
> "Oscar" wrote:
>
If[vbcol=seagreen]|||> In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the
> limit per database.
However, roles are also stored in sysusers, cutting down number of users to
half. Below is a line
from sp_grantdbaccess:
where uid >= 5 and uid < (16384 - 1) -- stay in users range
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:257A5B67-9708-4FA0-B58C-897000078781@.microsoft.com...[vbcol=seagreen]
> Hi
> Can't find documentation, but master.dbo.syslogins does not use a counter.
> Good so far. Limitation here is number of unique combinations of charaters
> that fit into "name" which is nvarchar(128)
> In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the
> limit per database.
> So, it looks like only a per DB limit. Think it is time for me to do a bit
> of an experiment.
> Regards
> Mike
> "Oscar" wrote:
>|||Thank You
"Aaron [SQL Server MVP]" wrote:

> Number of users per database = 16,379
> Number of roles per database = 16,367
> Number of concurrent connections = 32,767
> However, if you are approaching any of these limits, your design will
> probably raise quite a few eyebrows...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Oscar" <Oscar@.discussions.microsoft.com> wrote in message
> news:4159DD0F-0B77-4783-8AEA-A779E3138700@.microsoft.com...
>
>|||Thank You
"Tibor Karaszi" wrote:

> However, roles are also stored in sysusers, cutting down number of users t
o half. Below is a line
> from sp_grantdbaccess:
> where uid >= 5 and uid < (16384 - 1) -- stay in users range
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:257A5B67-9708-4FA0-B58C-897000078781@.microsoft.com...
>
>|||Thank You
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Can't find documentation, but master.dbo.syslogins does not use a counter.
> Good so far. Limitation here is number of unique combinations of charaters
> that fit into "name" which is nvarchar(128)
> In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the
> limit per database.
> So, it looks like only a per DB limit. Think it is time for me to do a bit
> of an experiment.
> Regards
> Mike
> "Oscar" wrote:
>|||Hi
Yes you are right....my head has been a bit too much in Sybase today.
Busy writing some scripts to test what really happens when the 2 tables hit
their limits.
Cheers
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OaEph9D7EHA.2572@.tk2msftngp13.phx.gbl...
> However, roles are also stored in sysusers, cutting down number of users
to half. Below is a line
> from sp_grantdbaccess:
> where uid >= 5 and uid < (16384 - 1) -- stay in users range
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:257A5B67-9708-4FA0-B58C-897000078781@.microsoft.com...
counter.[vbcol=seagreen]
charaters[vbcol=seagreen]
bit[vbcol=seagreen]
If[vbcol=seagreen]
>