Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mahmoud 4 posts 74 karma points
    Aug 22, 2019 @ 06:57
    Mahmoud
    0

    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 .

  • Shaishav Karnani from digitallymedia.com 330 posts 1536 karma points
    Aug 22, 2019 @ 07:42
    Shaishav Karnani from digitallymedia.com
    0

    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.

  • Mahmoud 4 posts 74 karma points
    Aug 22, 2019 @ 07:45
    Mahmoud
    0

    Thanks Shaishav for the helpful reply , but actually the application runs on azure and the requirement is to use sql server authentication.

  • Shaishav Karnani from digitallymedia.com 330 posts 1536 karma points
    Aug 22, 2019 @ 07:54
    Shaishav Karnani from digitallymedia.com
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft