Copied to clipboard

Flag this post as spam?

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


  • Vijay Koparde 3 posts 73 karma points
    Sep 06, 2022 @ 09:13
    Vijay Koparde
    0

    SQL Authentication to Windows Authentication for Umbraco frontend application

    I'm using SQL Authentication in the connection string of the Web.config of our publically hosted Umbraco frontend application. however, If I want to use Windows Authentication, what all changes are required to be made on the web.config file's connection string.

    Please let us know if this is possible. (I'm using Umbraco version 8.17.2)

  • Nikhil Prajapati 19 posts 131 karma points
    Sep 22, 2022 @ 09:11
    Nikhil Prajapati
    0

    Hi Vijay,

    Connection string should be like below for windows authentication.

    connectionString="server=serverName;database=databaseName;Integrated Security=True"

    Hope this work for you.

    Cheers

  • Vijay Koparde 3 posts 73 karma points
    Sep 25, 2022 @ 19:03
    Vijay Koparde
    0

    Hi Nikhil,

    I appreciate your help so much.

    I've tried this method and it's not working. as I have a website that is publically hosted and anyone from the world can access it.

    Can you advise any other ways?

    Kind regards,

    Vijay Koparde

  • Nikhil Prajapati 19 posts 131 karma points
    Sep 26, 2022 @ 07:48
    Nikhil Prajapati
    0

    Sure Vijay,

    Can you please share your appsettings.json file? I will check & help you out.

  • Vijay Koparde 3 posts 73 karma points
    Sep 27, 2022 @ 06:23
    Vijay Koparde
    0

    Hi Nikhil,

    I cannot find my appsettings.json file, what will be its default directory?

  • Nikhil Prajapati 19 posts 131 karma points
    Sep 27, 2022 @ 06:48
    Nikhil Prajapati
    0

    Oh, okay. I was under the impression of V9. But I just checked it is V 8.x.

    So for V8, please share your web.config file.

    enter image description here

Please Sign in or register to post replies

Write your reply to:

Draft