ReportManager and domain name change

Hi,
The fully qualified domain name of the reporting services server has changed
and that caused the Report Manager to stop working. Iâ'm using SQL 2000
Reporting Services on Windows Server 2003 .
I tracked the issue down to /Reports/Pages/Report.aspx page where that page
calls the actual report in a IFRAME and the IFRAME is calling the report with
the old domain name.
I found a configuration setting <UrlRoot> in the C:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config config
file that used the old domain name. However, even changing that property to a
new domain name had no effect (tired touching web.configs, bouncing the
website).
Any suggestions greatly appreciated.
Thanks,
AlexFrom an issue I had with something similar on my CRM system here are some
notes passed on to me that I think might help you. I was changing mine from
a fullqualified domain name to a domain.local name but these would still
apply for you as well:
These instructions assume you are using SQL 2000 SP4.
First, on the server where SRS is installed, open the two files
rswebapplication.config at C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager and rsreportserver.config at
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
with notepad and search for https://fqdn.yourdomain.com. Once you find this
replace it with https://YourNetBiosServerName.domain.local and save and
close the files.
On the same server, open the registry and modify the following registry
values at HKLM | SOFTWARE | Microsoft | Microsoft SQL Server | 80 |
Reporting Services to replace https://fqdn.yourdomain.com/ReportServer with
https://YourNetBiosServerName.domain.local/ReportServer.
RSVirtualDir - should be
https://YourNetBiosServerName.domain.local/ReportServer
WAVirtualDir - should be https://YourNetBiosServerName.domain.local/Reports
Gary
"alex" <alex@.discussions.microsoft.com> wrote in message
news:2E0195F3-5F67-4196-A119-9CDFC08656DA@.microsoft.com...
> Hi,
> The fully qualified domain name of the reporting services server has
> changed
> and that caused the Report Manager to stop working. I'm using SQL 2000
> Reporting Services on Windows Server 2003 .
> I tracked the issue down to /Reports/Pages/Report.aspx page where that
> page
> calls the actual report in a IFRAME and the IFRAME is calling the report
> with
> the old domain name.
> I found a configuration setting <UrlRoot> in the C:\Program
> Files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config
> config
> file that used the old domain name. However, even changing that property
> to a
> new domain name had no effect (tired touching web.configs, bouncing the
> website).
> Any suggestions greatly appreciated.
> Thanks,
> Alex
>