Update password for database connection for a site

[sai_santhoshp14907680]

I have got a request from a client stating to Update password for database connection for a specific site, how to do that in ColdFusion 11.

[metajohnm]

This is something that is can be handled using the ColdFusion administrator. Do you have access to this?

Import question to ask... Do any other sites are applications us this same connection?

[sai_santhoshp14907680]

I am having admin access to the ColdFusion admin page, I have multiple applications running on the server can you please suggest me how to identify which application is using which data source connection.

[Dave Watts]

If you don't know which application is using which database connection, you will have to look in the code for the application in question and see what it's using. You might be able to identify that by enabling debug output, then looking at the CFQUERY tags displayed by that.

This is actually a fairly common problem with CF servers running many applications. CF doesn't really give you a way to directly identify this information, but you can work around this by keeping the information yourself, or by using sandboxes and keeping the datasources tied to those individual sandboxes.

Dave Watts, CTO, Fig Leaf Software

[sai_santhoshp14907680]

Once i find which data source is being used by my application, can you please tell me to update the password for that data source.

[Dave Watts · Accepted solution]

You can do that within the CF Administrator under Data Sources.

ColdFusion Help | Administer ColdFusion

Dave Watts, CTO, Fig Leaf Software

[sai_santhoshp14907680]

Before resetting the password i would like to know what is the current password of the data source, where can i get it and how to decrypt it, if it is encrypted.