We installed SQL 2005 on a Win2k3 server that was previously running SQL 2000.

The issue we encountered was that local SQL login accounts were not migrated properly ... while all other Active Directory accounts did migrate without issue.

This was frustrating in that we also had to reassign security to objects for the missing local accounts, after intervening to get them configured in 2005.