Entity Framework 4.3 with SQL Server Express migration exception

Question

I've set up a (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 on the call migrator.Update():

The INSERT permission was denied on the object '__MigrationHistory', database 'MyDataBase', schema 'dbo'.

On the server I've done the following:

Created a user with SQL Server credentials
Created a database called MyDataBase

Any ideas?

Did you get your user any permissions on your database? When you create SQL credentials it is actually only login. You than have to create user in the database associated with login and give it permissions for allowed actions on the database. — Ladislav Mrnka
– Ladislav Mrnka, Commented Mar 30, 2012 at 9:10
@LadislavMrnka I created a new user and new database and now it works, I think I messed up the permissions in the first database. Thanks. — Marthijn
– Marthijn, Commented Mar 30, 2012 at 9:45

Kirsteins · Accepted Answer · 2015-08-29 13:33:22Z

6

The DB roles db_denydatareader,db_denydatawriter must be unchecked for the created user.

edited Aug 29, 2015 at 13:33

Kirsteins

27.3k8 gold badges79 silver badges78 bronze badges

answered Aug 28, 2015 at 19:33

Mano Nandu

1592 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Buchannon Over a year ago

This worked for me as well. Database -> Security -> Users -> Right cick your user -> properties -> Membership --> uncheck "db_denydatareader" and "db_denydatawriter"

RepDbg · Accepted Answer · 2015-09-03 16:27:01Z

1

I was getting this error too. To fix it I added db_owner to my user's "database role membership", and checked the db_owner check box under "schemas owned by this user" (SSMS 2008).

answered Sep 3, 2015 at 16:27

RepDbg

1491 silver badge4 bronze badges

Collectives™ on Stack Overflow

Entity Framework 4.3 with SQL Server Express migration exception

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related