Set up SQL 2005 Reporting Services

After installing SQL Reporting Services, it needs to be configured

1. Log onto the server via Remote Desktop
2. Click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > Reporting Services Configuration
3. On the Report Server Virtual Directory page click New
4. In the dropdown list each Web site is identified by its descriptive name. Although the Web site might be configured for a specific IP address or host header you do not specify the IP address or host header until later when you edit the configuration files
5. Click Apply to create the report server virtual directory
6. Test the site by visiting http://IP_or_domain.com/reportserver

The site will be password protected -- you should be able to use your login as well. If you get HTTP 401 errors, then open Directory Security on the site and change it to use Basic Authentication instead of Integrated Windows Authentication or check out http://support.microsoft.com/kb/871179

If you are getting HTTP 400 errors you need to modify the configuration files created by the configuration tool.

1. Open C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
2. Backup RSWebApplication.config, then open it and modify it as follows

<ReportServerUrl>http://IP_or_domain.com/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Some links on this topic from MSDN
http://msdn2.microsoft.com/en-us/library/ms155921.aspx
http://msdn2.microsoft.com/en-us/library/ms403426.aspx