The .net application host with iis gives a database access error

Question

I have a .Net Core 2.0 application that I host in IIS 7.

With IIS Express, the application works fine, and I can successfully connect to the database. With IIS, I get this error:

Unable to open the database "Books"requested at login. Login failed. Login failed for user 'DOMAINNAME\PCNAME$'.

My connectionString's file is appsettings.production.jsonas follows:

"ConnectionStrings": {
 "BooksDatabase": "Server=PCNAME\\SQLEXPRESS;Database=Books;user id=iisAccess;password=iisPassword;Trusted_Connection=True;ConnectRetryCount=0;MultipleActiveResultSets=true"
};

What am I doing wrong and why does it say that "login failed for" DOMAINNAME \ PCNAME $ "" when I put the credentials user id=iisAccess;password=iisPassword;in my JSON file?

Answer 1

You are requesting Windows authentication:

Trusted_Connection=True

.

:

IISExpress . , Windows. IISExpress, , Windows - , SQL Server.

IIS, , . , . , IIS , "" . , SQL Server, SQL "" , DOMAIN\MACHINE $.

Answer 2

, ASPNETCORE_ENVIRONMENT (.. , Production).

( ) ASPNETCORE_ENVIRONMENT Production. IIS , Load User Profile True.