Copied to clipboard

Flag this post as spam?

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


  • lori ryan 239 posts 573 karma points
    Dec 15, 2020 @ 17:17
    lori ryan
    0

    Encrypting the Umbraco Connection String - SQL Authentication

    I have been asked it is possible to encrypt the Umbraco connection string? The current project has to use SQL Authentication. Any thoughts? Any pointers or help would be most welcome

  • Huw Reddick 1727 posts 6066 karma points MVP c-trib
    Dec 15, 2020 @ 17:48
    Huw Reddick
    0

    I gues that largely depends how Umbraco retreives the connection string, if it using standard .Net methods to do that then you can encrypt the connection strings section using aspnet_regiis.exe

    encrypt connection string

  • lori ryan 239 posts 573 karma points
    Dec 15, 2020 @ 18:02
    lori ryan
    0

    Thanks for coming back to me, is it possible to do it via code OR part of ci/cd (azure dev ops) rather than command window?

  • Huw Reddick 1727 posts 6066 karma points MVP c-trib
    Dec 15, 2020 @ 19:11
    Huw Reddick
    0

    not sure as I think it has to be done on the server it is deployed on, but I will ask our devOps guy tomorrow for you

  • Huw Reddick 1727 posts 6066 karma points MVP c-trib
    Dec 18, 2020 @ 16:19
    Huw Reddick
    1

    it would not be possible to do as part of devops build etc, however you may be able to do it in code by creating an encryption provider.

    Have a read of this Encrypting web.config sections

Please Sign in or register to post replies

Write your reply to:

Draft