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...
> 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|||> 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...
> 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|||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...
> > 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
>
>|||Thank You
"Mike Epprecht (SQL MVP)" wrote:
> 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|||Thank You
"Tibor Karaszi" wrote:
> > 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...
> > 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
>
>|||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...
> > 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...
> > 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
>