IIS
Web Server
-
The SQL Server Windows credentialing to work with ASP.Core and other IIS Web Sites
So somewhere in the backwaters of connecting an IIS hosted web app (a.k.a ASP Core 2.x SPA like app that uses SQL Server as it’s data host), we find the secret not so secret way to wire up a Windows Credential for Database access. Write this down: IIS AppPool\DefaultAppPool or Generically IIS AppPool\<Name My Pool> We start here in IIS with our favorite App Pool- Now this one is just for example… an ASP Core app pool, of course, would have a No Managed Code like this: Either way, the SQL Windows credential set up is the same…. In SQL server the new login looks like this: Note the IIS…


