We are planning to upgrade our web server, and also upgrade the MSDE database on that web server to SQL Server Express 2005. So, I installed SSE 2005 on my test PC. Then, I performed a full backup of the MSDE databases: master, model, msdb, and my database that contains the data.

I would like to just "restore" these databases into SSE 2005 on the test PC, so that user accounts, etc, also get ported over. Will this work? Or do I have to import only my user-created database backup, and then manually set up the user accounts etc. on SSE 2005? In other words, assume that a server with MSDE crashed, and you want to reinstall everything but upgrade first to SSE 2005 and then do a full database restore. Is this possible?