I’ve just installed Microsoft Data Protection Manager 2007 on a Windows Server 2008 RTM, and I ran in to an issue when trying to access the report functionality of DPM.

The error message that you get in DPM is:

3013: DPM could not connect to to SQL Server Reporting Services server because of IIS connectivity issues.

DPM will give you a suggestion on how to fix this, but that didn’t work for me.

If you try to access SQL Reporting Services directly from Internet Explorer, you will get an error message like this:

HTTP Error 403.1 Forbidden
You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run.

This error led me to a KB article from Microsoft KB938245 which explains the error.

At the bottom of the article you’ll find this text:

Problem 2

When you run a script to configure the virtual directory for the report server, you receive the following error message:

HTTP Error 403.1 Forbidden
You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run.

Cause of Problem 2

This problem occurs because of a new permission requirement in IIS 7.0. This permission requirement is for ISAPI extensions that use a wildcard (*) script mapping.

Workaround for Problem 2

To work around this problem, follow these steps:

1. Click Start, click Run, type inetmgr, and then click OK.

2. In Internet Information Services (IIS) Manager, expand Web Sites, expand Default Web Site, and then click the virtual directory for the report server.

3. Under Features View, double-click Handler Mappings.

4. Under Actions, click Edit Handler Permissions.

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

This does however contain one little error, in step 4 above you should click on Edit Feature Permissions.

That solved the reporting issue for me.