Is there a limit to the maximum number of concurrent users connected to SQL Server 2008? I am guessing computer resources determine that limit (if it exists), but I am also wondering if there is a theoretical limit. I have tried googling the answer, but all the information I have found is based upon earlier versions of SQL Server. If there is a limit, does it apply to just a database or a SQL Server instance?
A:
It also depends on the licensing model for your server.
http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx
William Leader
2010-06-16 16:27:33
Isn't licensing just a way to be "legal"? As far as I know, Microsoft does not programmatically prevent users from connecting to the server computer.
2010-06-16 16:36:22
This is neither a hard nor enforced limit.
gbn
2010-06-16 17:54:55
+2
A:
http://msdn.microsoft.com/en-us/library/ms143432.aspx
User connections: 32767
František Žiačik
2010-06-16 16:27:53