is there any limitation for client nodes in free SQLServer Express. How many nodes it supports in multiuser environment ?
+2
A:
"SQL Server Express (SSE) doesn't have any concurrent user or connection limit that is specific to the SKU."
See this MSDN forums thread.
If you are talking about the number of instances on a machine, that is 16, as documented in this MSDN article.
Oded
2010-01-06 09:55:57
Doesn't the 5 concurrent user limit apply to MSDE? I believe it's gone for SQL Server Express.
shunty
2010-01-06 10:21:46
@shunty - correct. Fixed.
Oded
2010-01-06 10:45:35
A:
I don't think there's any limit to the number of concurrent users:
"There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve acceptable response times from a SQL Server Express database" from this link (that has already been mentioned previously).
If you're pushing it that hard then you really ought to have one of the non-free versions anyhow.
shunty
2010-01-06 10:19:44