Loading

Error while connection .net core api to sql server

Rahul Sharma

I created an api in .net core 3.1 with Sql Server 2014 as backend. Its working good on local but after hosting its giving me error "SqlException: Cannot open database "stateElection" requested by the login. The login failed.

Login failed for user 'IIS APPPOOL\jwttoken'."

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
If you don't change, each app pool has it's own identity.Add a new user to your database StateElection . In the "Security/Users" subnode of your database. make user member of the db_owner role
0