Hi All ,
we have an application that has two connection strings (one for app db and the other is for Umbraco db) and we needed to make an encryption for connection strings on web.config .
we was able to do this for our db but we are not sure how to do this for Umbraco.
I there any way to configure Umbraco to use some decryption mechanism to decrypt the connection string before reading it .
You could use Windows Authtentication and you will not require password in the Web.Config.
If you create an Application Pool in IIS, set it up to run as a Windows User that has access to the database, then add the Umbraco system to run in that application pool, you can use a database connection string like: data source=localhost;initial catalog=Umbraco;integrated security=True and the system will work fine.
Encrypting Connection String
Hi All , we have an application that has two connection strings (one for app db and the other is for Umbraco db) and we needed to make an encryption for connection strings on web.config .
we was able to do this for our db but we are not sure how to do this for Umbraco.
I there any way to configure Umbraco to use some decryption mechanism to decrypt the connection string before reading it .
Hi Mahmoud,
You could use Windows Authtentication and you will not require password in the Web.Config.
If you create an Application Pool in IIS, set it up to run as a Windows User that has access to the database, then add the Umbraco system to run in that application pool, you can use a database connection string like: data source=localhost;initial catalog=Umbraco;integrated security=True and the system will work fine.
Thanks Shaishav for the helpful reply , but actually the application runs on azure and the requirement is to use sql server authentication.
Hi Mahmoud,
I think this articles provide a good approach on how you can hide the private information on azure.
https://www.hanselman.com/blog/BestPracticesForPrivateConfigDataAndConnectionStringsInConfigurationInASPNETAndAzure.aspx
Please can you try and do share your findings.
Regards,
Shaishav
is working on a reply...