Tim
Tim

Reputation: 61

Stop SQL Reporting Server Hijacking /Reports

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?

Upvotes: 6

Views: 358

Answers (3)

azzlack
azzlack

Reputation: 1191

You can also change the port it listens to via the Reporting Services Configuration Manager. I have set mine to 8080 instead of 80, and it has solved the problem for me.

Upvotes: 0

Will Appleby
Will Appleby

Reputation: 486

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!

Upvotes: 10

Phil
Phil

Reputation: 4092

Assuming you are using SQL Server 2008 R2 reporting services you can do this via the Reporting Services Configuration Manager.

But consider telling us the version of reporting services.

Upvotes: 0

Related Questions