We've resolved this issue so I thought I would post the
solution for others that may experience this in the future.
The problem was in the web.xml file which had the following
location on my server:
C:\CFusionMX7\wwwroot\WEB-INF\web.xml
In that file there are two sections that nee to be active for
RDS to work properly. These sections are clearly identified as RDS
sections. Evidentally the default file from the installation has
these commented out which caused the HTTP Error 404 I was
receiving.
In our situation the default file had been restored with
these two sections commented out, consequently RDS would not work
properly.