I have got the following issue with DPM 2007 which is installed on a Server 2008 x64 machine. If I open the Administrator Console and click on Reporting, I get the well known ID 3013 error message: DPM could not connect to SQL Server Reporting Services server because of IIS connectivity issues.
The reporting feature was still ok a couple of weeks ago, but suddenly there seems to be a problem. This is what I tried to fix it: - Run Internet Information Services (IIS) Manager, expand Web Sites, expand Default Web Site, and then click ReportServer$MS$DPM2007$ - Under Features View, double-click Handler Mappings - Under Actions, click Edit Feature Permissions - Click to select the Scripts check box, and then click OK. - Restart IIS, SQL Server Reporting Services (ReportServer$MS$DPM2007$) and World Wide Web Publishing Service
Unfortunately it did not solve the problem in my case. I went through some other IIS settings and noticed the following connection string of ReportServer$MS$DPM2007$: data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
Because of the fact that we do not even use SQL Express (we use SQL Server 2005), I am not sure if this is correct.
I would really appreciate if someone could help me to solve this problem. Thanks in advance!