Currently our Intranet website using DNN 3.2.2 runs off MSDE. And recently we have just added our 200th user. Whoo. But there is no way that we have that many users on the site at once. We would be lucky to have about 5-6 at the same time. Anyways, my company wishes to expand the user base further, so there is a possibility that the users will increase dramatically.

I have been asked to investigate the expansion by doing a few things:

1. I read that the MSDE database can have a maximum of 23 concurrent users. What does that mean for DNN if that limit is reached? Is this limit reached easily? What are the implications?
2. I have successfully migrated MSDE to SQL Express 2005 without any troubles on the development server. I still run 3.2.2 using the .net 1.1 framework but have changed the database provider. If i implement this in place of the MSDE engine will it solve user issues? Will it cause performance problems?

My thoughts are to just implement SQL Express 2005 and migrate the database across. Would this be a good idea?

Help would be much appreciated.