TechNote (Archived)

RDS connections from Report Builder fail on ColdFusion MX 7.0.1 and 7.0.2 with certain IIS configuration

Issue

If the Integrated Windows Authentication option is checked and the Anonymous Access option is unchecked in Directory Security in IIS (port 80), RDS connections to the ColdFusion server will fail from the Report Builder with the following error:

 The following error occurred while trying to connect to the RDS Server: HTTP/1.1 401 Access Denied.

This is logged as Macromedia issue 61239.

Solution

Since the Administrator is secured by the admin password, it is not necessary to use the IIS Integrated Windows Authentication.

To avoid this issue, use one of the following solutions:

Install ColdFusion using the integrated web server (port 8500).
Turn off IIS Integrated Authentication on the CFIDE directory (use the admin password to secure it instead).