Wednesday 13 April 2011

Sql Server Reporting Services 2005 Issue

Again SSRS 2005 has stopped working.

This time it follows install of Sql Server 2008 developer edition on my machine so I've been trying to figure out how to get both working on the same box - it is possible according to the documentation but there is no mention of how.

Unfortunately I am getting the following message when attempting to connection to Reporting Services via SQL Management Studio "unable to connect to the remote server. No connection could be made because the target machine actively refused it."

Now that's not very nice is it, I ask nicely & it does nothing.

Anyway after a few weeks of digging I've finally found my problem is not related to the Dev 2008 install - it is in fact our network wide security settings, they have been changed!

So the solution was to go into IIS Admin console, goto the properties of my default web site (which hosts my SSRS pages) and goto the Home Directory tab and then change the Execute Permissions to Script and Executables.

Job done.