Sign in Register
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

    Copy Link
  • Huw Reddick 1929 posts 6717 karma points MVP 2x 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

    Copy Link
  • 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?

    Copy Link
  • Huw Reddick 1929 posts 6717 karma points MVP 2x 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

    Copy Link
  • Huw Reddick 1929 posts 6717 karma points MVP 2x 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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft