Creating default IIS application pool user in SQL
If you are using the default application pool user in IIS:
then you should add a login for that in SQL Server:
Then check that the Login properties for the user are set as below:
If you are using the default application pool user in IIS:
then you should add a login for that in SQL Server:
Then check that the Login properties for the user are set as below: