Has anyone experience using the Microsoft Desktop Engine (MSDE)? We have a customer that wants to move their episerver3-installation to a new server and use the MSDE database.
I have read that MSDE is only recommended for web sites with up to 25 concurrent users, but is that each visitor on the web site or is it each connection to the database? Does anyone has any recommendations or tips?
We are running an Intranet for one of our clients on MSDE 2000A for a little over a year now with no problems.
The only setback from my point of view is that it doesn't have its own user interface. You have to use the Osql Utility instead. OR better yet, connect to it from another SQL instance that has the Enterpise Manager tools, i.e. Standard, Enterprise, or Developer edition.
See the following articles:
How to use OSQL to manage MSDE 2000
http://support.microsoft.com/kb/325003/
When to choose MSDE 2000
http://support.microsoft.com/?kbid=321518
/Leif