In doing my first SQL Reporting Services install, I hit a snag. Using all of the SQL installation defaults, SQL Reporting Services requires two urls:

• One for the Report Server Web service, which is http://servername/reportserver
• One for Report Manager, which is http://servername/reports
  Technorati Tags: SharePoint,SQL Reporting Services

If you have SharePoint installed and you use the default Intranet Portal template, you’ll get a url collision because the template creates a subsite called Reports. SharePoint will never get a chance to process any requests to http://servername/reports because the Reporting Services Report Manger will get it first. This issue is described in detail at http://technet.microsoft.com/en-us/library/bb630449.aspx

The solution I used is described in the above web page which is to specify a different url for Report Manager:

• Start the Reporting Services Configuration tool and connect to the report server instance.
• Click Report Manager URL.
• Specify the virtual directory. I changed it to http://servername/reportmanager

Voila, MOSS now can handle requests to the Report Center site using the url http://servername/reports.