Entity Framework 4.3 with SQL Server Express Migration Exception
I have installed (remote) SQL Server Express for my ASP.NET MVC with Entity Framework 4.3 project. On my local machine using SQL Compact, everything works fine. When I try to connect to the SQL Express server I got the following error when called
The INSERT permission was denied on the object '__MigrationHistory', database 'MyDataBase', schema 'dbo'.
On the server, I did the following:
- Created a user with SQL Server credentials
- Created a database called MyDataBase
source to share