Connecting to MS SQL using php?

Question

PHP

There is a server on IIS, on which various scripts are executed, which in turn connect to the SQL server.
I configured connection with IIS, the account of the domain user is picked up.
But then the problem is - the SQL server is configured for windows-authorization. Scripts work in IE. They don’t work in other browsers, but if you run the script once in IE, then it starts working in the others, however, for a short time, after which I again get the NT AUTHORITY \ ANONYMOUS LOGON error

Answer 1

As for me, you have configured IIS incorrectly.
In web.config, set Authentication to None or Form.
Run the application pool from a domain account with minimal rights.
In SQL, create a login for this account and assign appropriate rights to it. Insert, Update, Delete, Select.
Edit the diagram by hand.
https://docs.microsoft.com/ru-ru/dotnet/api/system...