Application Pool vs Windows User RRS feed

  • Question

  • User1030746581 posted


    Ordinarily, I would install SQL Server and IIS on two, separate machines, and run the IIS app with a Windows user account.  I have seen posts for assigning Windows and SQL Server to the Application Pool.  This seems to necessitate running SQL Server and IIS on the same machine.  I am deploying a .NET Core app to Azure.  Are there any thoughts on these two strategies?

    Another option is to use an Azure SQL Database, rather than SQL Server running on a VM.  However, that seems to require using SQL authentication instead of Windows authentication.


    Wednesday, June 22, 2016 6:09 PM


  • User753101303 posted

    I noticed recently https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/ (currently in preview). Might worth a check to the portal to see if they added some options for SQL Server/App Services.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, June 22, 2016 6:41 PM