Cloud Computing, Blockchain, AI, DevOps, Security, Software/Solution Architecture, Azure, AWS, GSP
Solution:
In order to run with service account you need below permissions:
• Logon as a service via GPO
• Local Admin permission on server
Also make sure you have permissions for the service account on the Database in order to make it work properly, if you were to use Integrated security.
Posted Also on StackOverFlow
Solution:
Are you moving changes from Development Environment to staging and you are getting above error, well there is a very quick and simple solution to the problem.
Just got to database and delete this table, and it will solve the issue, given that you already have moved the changes to the required tables etc using SQL compare or any other tool.
_MigrationsHistoryConsiderations and Other Solutions:
There is an other approach to automatically move the changes to database by using below code in configuration.cs file in Migrations folder.
AutomaticMigrationsEnabled = true;Please for the love of God don’t go for drop and recreate database option, as you will lose data when accidentally code is moved to staging or production, code as given below(Warning, You will lose data by using this)
Database.SetInitializer<NameOfDbContext>(new DropCreateDatabaseIfModelChanges<NameOfDbContext>());