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)
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)
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
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
Sure Vijay,
Can you please share your appsettings.json file? I will check & help you out.
Hi Nikhil,
I cannot find my appsettings.json file, what will be its default directory?
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.
is working on a reply...