DPM could not connect to SQL Reporting

I needed to pull some reports on our backup in Data Protection Manager. So I clicked on Reporting in Data Protection manager and it threw an error like this:

DPM could not connect to SQL Server Reporting Services 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.

Apparently there is a permission requirement in IIS 7 for ISAPI extensions that use a wildcard script. DPM uses this.

So you have to go into IIS 7 and set the permission for script to resolve this. Here are the steps:

Open up Server Manager expand Roles, expand Web Server (IIS).

Read more