I was concerned when I was pointed towards this in the SQL Server Express docs in an earlier CTP release:
"When a process attaches to a SQL Server Express Edition database (.mdf file), the process must have administrative permissions."
I thought "Oh no" we are back to the “Please Mr Hoster can you attach this database for me and provide me with the connection string so that I can update my config file”… or even worse hosted access databases. Furthermore what about running as a least-privilege user account (LUA) on the development box... vent vent.
Well I was pleasantly surprised when I discovered ALL these issues have already been addressed!
On another note:
This could be a good alternative for a dedicated single box single user hosted solution... bearing in mind SQL Server Express supports ~50 instances, 1gb ram and a single cpu.
This posting is provided "AS IS" with no warranties, and confers no rights.