Moving SQL to a new server

Just moved MSDE 2000 to a new server with MSDE 2005. Well worth the update as MSDE 2005 is a free download as well and is way better than the admin consol. Other than not having a backup agent MSDE 2005 looks and feels very much like good old SQL 2005.

Here is the link to get to MSDE 2005 express: http://www.microsoft.com/express/2005/sql/default.aspx

Here's an article to set up a backup routine for MSDE:
http://www.sqldbatips.com/showarticle.asp?ID=27

Process I did to move to a new server:

1. Make backup of DYNAMICS and company databases
2. Run capture login scripts found at: https://mbs.microsoft.com/fileexchange/?fileID=879594a6-60ee-421f-b6ab-4d77da3aba22
3. Install MSDE on new server (Mixed mode)
4. Install GP on new server
5. Copy output from #2 and run on new server (will automatically run against master database)
6. Restore DYNAMICS database and company database to new server (All tasks>>restore>>type in database name exactly as it was on previous server)
7. Change ODBC connections on workstations to point to new server
8. Update Dynamics.set file on all workstations to point to new shared directory with new reports.dic file location

Process could also be used for regular SQL installs.