We have a client that needs to keep costs down and we want to implement a
..NET 2.0 solution with SQL Server. The client suggested MySQL but we would
prefer SQL Server for ease of use with ASP.NET.
Is it possible to use SQL Express on a web server for an AP.NET app with a
limited number of users? Any constraints or issues?

The main constraints are the number of processors is limited to one and the
memory is limited to 1GB. If that's enough to handle your customer's load,
you should be OK. Small web sites are a primary focus of SQL Express.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"ML" <schooner (AT) accesswave (DOT) ca> wrote