I'm experimenting with some SQL Server 2005 Express edition features on a web page and hitting all sorts of issues. This article on MSDN helps explain some of the issues I'm having (especially around the User Instance=True connection string attribute). Unless I'm missing something simple (which is possible), this is an odd system -- and I hate the fact that I need to switch the True to False when I deploy my web application to a web server. The convenience of having a private local SQL Express database is lessened by the need to make configuration file changes to make it work properly.