Maximum Number of Database Users and Roles

From: Barry (no_one_at_home.net)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 09:14:00 -0500

I unfortunately found out during a late night update that the maximum number
of security accounts for sql server is 16379
(http://support.microsoft.com/?id=303879).

I have a web site that I had/have to change the security model for which was
originally setup using a Windows Domain Group and users to access our sql
server database. We were using mangled url's to pass the username and
password to our site, which was fine, but recently, MS removed the ability
to mangle the url. Our customers want the ability to pass their users from
their site to our site seemlessly without any pop-up dialog (i.e. basic
auth). One of our clients have approximate 40,000 users that need to be
setup for the site. We are trying not to rewrite hundreds of stored procs
to add the username and password parms, so we are kinda in a bind.

How are you accessing your database using sql secrutiy accounts with > 16379
users? Each user has to have a unique login, and we would like to use a
built in security model, but we cannot use the Windows domain groups.

Thanks,
Barry

Relevant Pages

  • Re: Microsoft Informational Alert
    ... > PSS Security Response Team Alert - SQL Security Recommendations ... > PRODUCTS AFFECTED: SQL Server ... Secure your SA login account with a non-NULL password. ...
    (microsoft.public.security)
  • Maximum Number of Database Users and Roles
    ... of security accounts for sql server is 16379 ... I have a web site that I had/have to change the security model for which was ... originally setup using a Windows Domain Group and users to access our sql ...
    (microsoft.public.sqlserver.server)
  • Re: [despammed] RE: SQL Slammer doing the rounds again?
    ... > and other ISA lists about how to allow inbound SQL connections ... > direct access to a SQL server across whatever network they're installed ... Network with over 10,000 of the brightest minds in information security ...
    (Incidents)
  • Re: SQL logins logged where
    ... you can't trace directly to a table but can use the> fn_trace_gettable function to load the trace file into a> table. ... If you are using SQL Server 7, use> xp_trace_setqueuedestination to set the destination to a> table. ... Security Tab does not give too many ...
    (microsoft.public.sqlserver.security)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)