25 MSDE Connections

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?
-Thanks
-Tom
I didn't know there was a hard limit but the soft limit was actually 5.
Over 5 concurrent connections and it would start to throttle back your
performance. I don't know for sure but the license probably states a limit
of 5 concurrent connections. It was not intended to be used for that many
connections. That is what the standard edition is for. A connection is
anytime someone is connected to the server. If the pool has 5 open
connections then it is 5 connections.
Andrew J. Kelly SQL MVP
"Tom Celica" <tom@.dontreply.com> wrote in message
news:V1%Ae.1617$_%4.505@.newssvr14.news.prodigy.com ...
> In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
> What is the definition of a "connection"? For example, if I create a
> connection pool of 5 connections in an application, does that count as 5
> against the 25?
> -Thanks
> -Tom
>
|||AFAIK there is no such limit. What makes you say that the limit is 25?
MSDE is optimized for 5 connections or less so if you want 25
connections you should probably be considering Standard or Workgroup
edition.
David Portas
SQL Server MVP