How many connections does MSDE support?

I always thought that MSDE supported up to 5 concurrent connections. However, I was just at Microsoft's Web site and it says that MSDE supports *25* concurrent connections:

http://www.microsoft.com/sql/msde/downloads/download.asp

There's a big difference between 5 connections and 25. Did MS just release a new version of MSDE? Is there a catch?Read carefully:

Basic websites that serve up to 25 concurrent users.

That means exactly that: In most cases, they expect that 25 concurrent users will be OK with the 5 concurrent OPERATIONS allowed, since a WEb application does not dedicate a connection to each user, and the web application will not be doing an operation for each user all the time.|||Hi Douglas, I have your book. :)

So, MS is assuming that 1 out of 5 Web users will have a database operation running? That's a pretty lofting assumption. So, if MS assumed that 1 out of every 10 Web users has a database operation running, then they could have said it serves up to 50 Web users?|||Hope you like the book! It makes a great Stocking Stuffer <g>.

As for the estimate of the number of users, it is just that. Your code might hit the database hard enough that you can only support 10 concurrent users, or you might be able to get 40.

Here is a link to a document that explains the Workload Governor.