We currently have a web reporter server running 2003R2 and SQL Server 2005. As 2003 is EOL in July we need to move this to a new server.
The plan was to rebuild the old server as 2008r2 and put SQL 2005 back on it and then reinstall Web reporter and restore the DB. Is this a good idea (and supported)? Is there a better way of doing it?