• We are doing a test run on updating SQL 2005 Standard Edition to SQL 2008 Standard Edition.

    We are doing this on a fresh install of the server and SQL 2005 and in the process, we renamed the computer after 2005 was installed.

    We did run the sp_dropserver and sp_addserver sprocs with the old name and new names and restarted our default instance.

    We have made it to the step entitled Reporting Services Authentication.

    We only have a default instance of 2005 installed. The text box labeled "Instance of SQL Server that hosts the report server database" is not editable and looks like it should contain the machine name, however it contains the old server name. Is there a chance that this value is coming from the RSReportServer.config file. Does anyone know of a way to check the contents of this file and of the best way to change the contents to reflect the new machine name?

    Thanks.