Can't Encrypt database.config connection string

[kittruong]

Currently managing several installations of AC 7.x. I have this one installation in which I can't encrypt the database.config connection string.

No error message, I check "Encrypt the connection string in..." and hit "CHANGE" and it says it updated. The database.config file is modified but the encryption is not there.

Encrypted file looks like this:
<connectionStrings>
<add name="AbleCommerce" connectionString="Server=XXX;Database=XXX;Uid=XXX;Pwd=XXX;" providerName="System.Data.SqlClient" />
</connectionStrings>

Unencrypted file looks like this:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="AbleCommerce" connectionString="Server=XXX;Database=XXX;Uid=XXX;Pwd=XXX;"
providerName="System.Data.SqlClient" />
</connectionStrings>

What gives?

[dgoranov]

Make sure you have a valid machineKey entry in the web.config file. I have not seen this issue, but this could be one of the reasons. Machinekey can be
generated using this link: http://aspnetresources.com/tools/machineKey

[sofaking]

I am also encountering this issue.

Putting a machinekey entry in the web.config did not work.

Also, I currently manage another site and they do not have a machinekey entry in the web.config but the database.config file is able to encrypt.

[sofaking]

Not sure if this is an AbleCommerce bug or not, but was able to manually encrypt the database.config from notes here:

viewtopic.php?f=42&t=5747&p=23126&hilit ... ing#p23126

[jmestep]

Did you check the file date on your database.config file to make sure the file changed? If not, it might be a permissions issue.