Isn't that illegal????  You should probably go buy it so you have the labs and what you do have will be legal.  Someone had to spend a lot of time...

After running this, did you run DBCC SHRINKDB('database')? 

No.  He should run the business and leave the database to others.    You NEED to run this maintenance on a regular basis.

How are you trying to connect?  What's your connection string look like?  Are you installing MSDE as a named instance or the default instance? 

Drop and recreate the index.

As you said, the INDEXDEFRAG does allow you to claim more space in the shrink db process.  If you want to maximize your shrink and have a good maintenance window:

1. ...

One other thing I forgot on my list (DOH).  After you restore the msdb database, you need to update the originating_server column in the sysjobs table to the new server. ...

It's preferrable that you do not.  SQL is a set based language and processes sets much more efficiently.  Having said that, here's an example: 

+ '[' + @dbname + ']'

The only problems we've experienced so far are instances where the server was attached to a SAN.  Make sure all your hardware is on the W2K3 compatability list and you...

RESTORE FILELISTONLY

   FROM DISK = 'c:\Northwind.bak'

--This will give you the list of the logical files.

RESTORE DATABASE TestDB

   FROM DISK = 'c:\Northwind.bak'

   WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',

   MOVE 'Northwind_log'...

1.  Look for sp_help_revlogin by searching the forums on http://www.sqlteam.com.  Run this script in the master database on the old server to script out all the logins, database users,...

Assuming you're using SQL Server Agent to schedule the jobs, you could run sp_update_job from osql.

You'll want to track Security Audit..Audit Object GDR Event.  With the view, you might also want to track Security Audit..Audit Object Derived Permissions.

Make sure you include the databaseid, object id,...

Why don't you just go to http://www.microsoft.com/data and download the MDAC from there?  Then you don't have to fool with the key or setup at all.