I came across a DPM server where I could not get into the Reporting tab.
It gave an error:
Could not connect to SQL Server Reporting Server because of IIS Connectivity issues.
On the computer on which the DPM database was created, restart the World Wide Web Publishing Service. On the Administrative Tools menu, select Services. Right-click World Wide Web Publishing Service, and then click Start.
The reported error number was 3013.
Of course in my case IIS was running and a restart of the service did not resolve the issue.
Turns out that IIS 7 has some additional security that stopped the connection.
So how to get it working again:
- Start the IIS manager
- Expand Websites and Default Website and click on the virtual directory for the Report Server (named ReportServer$MS$DPM2007$ in my case)
- In the middle of the screen double click on Handler Mappings
- On the right hand side click on the action Edit Feature Permissions
- Check the checkbox for scripts
- restart IIS
You should be good to go!