I have spent about a day on this without success.

Does anyone know of a method to encrypt a connection string to a MSSQL database from within a web.config file where the website is hosted on a shared hosting environment. I have managed to encrypt the connection and get it to work on a dedicated machine using aspnet_regiis. However, when moving the site to my site provider I get the following message:

"Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: The RSA key container could not be opened."

Anyone solve this issue.

Thanks in advance.