Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2008-03-18 : 09:57:36
|
| Hi everyone,I was asked a question that kinda stumped me....The question was"how many users can you have in a sql system"I know you can only have 32k concurrent users,but it never occured to me as to how many unique users can be created in a single SQL server.Does anyone know? |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-03-18 : 09:59:17
|
| i think i'd come back with "what licenses do you have?"Em |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-18 : 10:01:08
|
| 32767 |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2008-03-19 : 09:47:51
|
| I have a four processor license enterprise version / sp4 the 32767 is concurrent user count |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-03-19 : 09:59:27
|
| then i think you're only limited by the concurrent user countEm |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-20 : 23:55:59
|
| >> the 32767 is concurrent user countNo, it's max connections sql supports. |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2008-03-21 : 09:16:07
|
| Wow -That is what i am saying....32767 concurrent connectionsbut how many users can be added into the available users |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 17:30:14
|
| You mean number of sql logins? Limited by syslogins table size which limited by available storage.By the way, concurrent users is different from concurrent connections since each user may open multiple connections. |
|
|
|
|
|
|
Silly question