My preference is #2, a clean install, and transfer the databases and server
settings.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"HenryT" <HenryT@discussions.microsoft.com> wrote in message
news:AFFEB59E-8CE9-44DB-92F7-3B97F3351610@microsoft.com...
> What is the best way to upgrade/migrate to SQL Server 2005 (including
> Reporting service)?
> 1. Upgrade in place
> 2. Set up another box for SQL 2005 and migrate
> 3. Set up another instance of SQL 2005 on the same box and migrate
> Thanks in advance for sharing your experience/suggestion on this.