No connection limitation with SQL Express 2005?

MSDE had the limitation of 25 concurrent connections.
It seems that SQL Express 2005 doesn't have this limitation. Is that
correct? Does Express support as many connections as the "full" SQL 2005
server?"the friendly display name"
<thefriendlydisplayname@.discussions.microsoft.com> wrote in message
news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> MSDE had the limitation of 25 concurrent connections.
No it didn't. It had a query governor which throttled performance after 5
concurrent workloads.
> It seems that SQL Express 2005 doesn't have this limitation. Is that
> correct?
Yes.
>Does Express support as many connections as the "full" SQL 2005
> server?
Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and 1CPU
which will impose some limit on the number of users it can serve.
David|||Hi
And to add, there are no SQL Server limits, but if you run on Windows 2000
Pro or Windows XP, the OS has a limit of number of incoming network
connection it accepts, and that is 10.
On Server editions of the OS's, there are no limits.
Regards
--
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/
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uxhcKhs5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> "the friendly display name"
> <thefriendlydisplayname@.discussions.microsoft.com> wrote in message
> news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
>> MSDE had the limitation of 25 concurrent connections.
> No it didn't. It had a query governor which throttled performance after 5
> concurrent workloads.
>> It seems that SQL Express 2005 doesn't have this limitation. Is that
>> correct?
> Yes.
>>Does Express support as many connections as the "full" SQL 2005
>> server?
> Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and
> 1CPU which will impose some limit on the number of users it can serve.
> David
>|||> And to add, there are no SQL Server limits, but if you run on Windows 2000
> Pro or Windows XP, the OS has a limit of number of incoming network
> connection it accepts, and that is 10.
IIRC, that is Redirector connections, not socket connections. Has anyone
tried more then 10 sql connections on XP?
--
William Stacey [MVP]