While setting up my first ColdFusion 2016 server I came across an interesting problem with RDS.
My problem was that I could not get RDS to connect via ColdFusion Builder 3.
The error when I would attempt a test connection:
Unable to contact RDS Server "[Remote Server]". This can be caused by incorrect configuration on either the client or the server. Please verify your connection details below or check your servers documentation on how to enable RDS for your server. The HTTP request to talk to your server returned with the following message: Error executing RDS command. Status Code: 404, Reason : Not Found
First I made sure RDS was enabled via the ColdFusion Administrator.
Removing the “!” and running an IISReset command instantly enabled the RDS connection.
In order to continue to secure the ColdFusion Administrator folders I added these entries to the uriworkermap.properties file:
!/CFIDE/administrator/* = cfusion !/CFIDE/adminapi/* = cfusion
Some things to remember when troubleshooting RDS:
An information technology professional with twenty two year's experience in systems administration, computer programming, requirements gathering, customer service, and technical support.