0

my coworker and I had a debate and I am looking for Reddit to resolve it! We have PHP web apps running on IIS and are looking to setup the security to the database using one approach:

-What would you call the method where the service account running the application pool authentication to the SQL Server database using its own credentials?

-What would you call the method where the users connecting to the app on the network authenticate to the apps SQL Server database using their own network credentials?

Which is “integrated authentication”?!

closed as off-topic by Max Vernon, Md Haidar Ali Khan, Vérace, dezso, Julien Vavasseur Oct 15 '18 at 8:00

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Md Haidar Ali Khan, Vérace, dezso, Julien Vavasseur
If this question can be reworded to fit the rules in the help center, please edit the question.

3

They are both "Integrated Authentication", as opposed to "SQL Authentication" which uses a user name and password stored in SQL Server.

The first is "Integrated Authentication With a Shared Servcie Account".

The second one "Integrated Authentication With a End-User Impersonation".

Not the answer you're looking for? Browse other questions tagged or ask your own question.