Applying existing migrations for ApplicationDbContext - cannot open database requested

So I have an ASP.NET MVC application that I deploy on the IIS using the Publish feature inside of Visual Studio. I have performed some changes to the existing version of the database and the application - this is what I did: I made very little changes to the database on the production server (just added a single column to two tables and made them FK to another table). Then I took the generate script from this production DB, went to the local (development) SQL server and ran the generate script to create the database locally. After this, scaffolded this local DB instance into VS (to get the modified model classes locally). Then, after some smaller modifications to the app (I was basically just adding some document upload functionality), I did the Publish and deployed that on the production server. However, I ran into the following error when I tried to log in the website: error screenshot Why does this happen? How can applying the migrations work through Visual Studio package manager command if I run the suggested Update-Database command locally (and from there I cannot reach the target database)? Thank you very much for your help.