In the rare case that you change the database server name after installing SQL Server Reporting Services 2005, you may have difficulty connecting to it with SQL Server Management Studio.
We successfully connected to the SSRS Server in Visual Studio to deploy reports and components, and accessed the IIS site to execute the reports. However, when attempting to open the site with Management Studio we got a connection error.
Unfortunately, the correction could not be made in the Reporting Services Configuration Manager.
To fix, you'll need to locate the file: rsreportserver.config
If you performed a default install, this can be found in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Open the file in Notepad and find the node <UrlRoot>
If you notice the name of your old server name there, change it to the correct name.
So
<UrlRoot>http://oldservername/reportserver</UrlRoot>
becomes
<UrlRoot>http://newservername/reportserver</UrlRoot>
After saving the file, stop and restart Reporting Services using the Reporting Services Configuration Manager.
