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).

Under Features View, double-click Handler Mappings.

On the right hand side, click Edit Feature Permissions.

 

Click to select the Scripts check box, and then click OK.

 

Now go back to DPM and click on the reporting tab it should look like this:

Print Friendly, PDF & Email

Leave a Reply