Stop SQL Reporting Server Hijacking /Reports

Question

How do you stop SQL server reporting services from hijacking the /reports virtual folder on ALL websites on the server it's installed on. Have just discovered that all the websites on the box with the reporting server on (its a dev box), have /Reports overridden by the reporting services manager. How do I turn this off?

Have tried stopping the service, disabling it in the config file, all to no avail (the service is still hijacking the url, you just get a "service unavailable" error instead of the report manager). Short of uninstalling reporting services, is there a way to switch this off?

Answer 1

I had the exact same problem - very annoying when your own web application uses a /Reports folder, couldn't understand why I was getting "File or Directory Not Found" errors on IIS when navigating to my reports page.

Phil is correct the easiest solution (using SQL Server 2008 R2) is to run Reporting Services Configuration Manager, connect to your local instance and change the Virtual Directory under "Report Manager URL" to something more unique (I used "/ReportingServices").

This fixed the problem and my /Reports folder was restored to my own web app!