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
    24 days ago
    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 14 posts 125 karma points
    1 week ago
    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
    5 days ago
    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 14 posts 125 karma points
    4 days ago
    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
    3 days ago
    Vijay Koparde
    0

    Hi Nikhil,

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

  • Nikhil Prajapati 14 posts 125 karma points
    3 days ago
    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