When you schedule something to run in the Reporting Services and when the report gets emailed to the requestors, by default, in the email, you'll see http://servername/reportserver/report....

So what happens that if you are on the network (which is most likely if the reporting services is used for a corporate), you may get some DNS error that "servername" machine not found.

You can change the "servername" to full qualified domain name i.e. servername.domain.com

Go to your Reporting Server machine and do the following:

• Open RSWebApplication.config (C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager) and change the value for key "ReportServerUrl" to "server.domain.com". Save changes.
• Open RSReportServer.config (C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer) and change the value for key "Services/UrlRoot" to "server.domain.com/reportserver". Save changes.

That's it. I personally would restart the IIS server and the SQL Server Reporting Services under Administrator Tools/Services. YMMV.

Hope this helps somebody.

2 Comments

• rplacido said Wednesday, October 8, 2008 2:07:53 PM

  RSWebApplication.config has been obsoleted. You can make both changes in RSReportServer.config

• B said Monday, November 10, 2008 8:05:12 AM

  Thanks, worked a charm!