"CREATE DATABASE permission refused in database'master'," says EF Code First.

c# ef-code-first entity-framework sql-server-2008

Question

I just want to quickly spin up the default database in my development environment.

How is the easiest way to get around this problem?

1
3
10/6/2011 9:46:28 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I once faced this problem and resolved it. The key is using SQL authentication instead of Windows'. This is the clearest way to specify the default db.

Try connection string in this way:

<add name="MFCConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MFC.mdf;Initial Catalog=MFC;Integrated Security=false;User ID=sa;Password=123"
  providerName="System.Data.SqlClient" />

remember to set default db of sa from master to MFC, and Integrated security = false. BTW, sa is normally disabled, so enable and test it in sql server management studio first.

3
9/6/2013 2:49:01 AM

Related Questions

code first entity framework 4.1 The permission to CREATE DATABASE was refused in the database'master.'

I just ran into this myself. The connection string name must match the class name of your DbContext subclass exactly. If it doesn't EF will not find the connection string and will try and fall back to doing something else (SQL embedded?) which doesn't work on my machine (I have full SQL Server installed).
entity-framework
asked by jlew

EF 5, Code First - Create a new database and run all migrations programatically

Just remove the "create database" step and use the migrations on their own. I put a sample project on ...GitHub..., but the important bit is...Configuration config = new Configuration(); DbMigrator migrator = new DbMigrator(config); foreach (string s in migrator.GetPendingMigrations()) { migrator.Update(s); }
c# ef-migrations entity-framework
asked by mike mckechnie

Entity framework code first - how to run Update-Database for production database

To add on what @David said already... ...Personally, I don't trust ...automatic updates... in 'live' scenarios, and I always prefer manual database administration (i.e. there is a problem with ...permissions... needed to create or alter Db - not to mention shared hosting etc.) - but from what I've seen migrations are pretty solid when it comes to ...
asp.net-mvc c# entity-framework
asked by NSGaga-mostly-inactive

EF Code Frirst: Before you update your database using Code First Migrations,

Bool param throwIfV1Schema throws exception that asp.net Identity model has been changed (updated to new version 2)....Change your IdentityDbContext constructor for one time migration:...public YourDbContext() : base("YourConnectionString", throwIfV1Schema:false){}
asp.net-identity entity-framework
asked by Arvis

Code First Existing Database vs EF Designer to Existing Database

In any case you'll have to synchronize the EDM (entity data model) and the DB. You have to make sure that the EDM is fully compatible with your database. If not, it will fail, no matter if it's Code First or you use a Model....The only difference is that:...using the designer you can do it graphically, and easyly set properties, column names, and s...
entity-framework
asked by JotaBe

How to update model working with EF code first with 'Code First from Database'

One more option is just delete the auto generated classes from the project and once again generate them. While following this approach only thing we need to make sure that is, we should give the same name for the data model(class name which inherits from DbContext ) as the previous one.Data model name is highlighted in below snap.
.net c# ef-code-first entity-framework entity-framework-6
asked by Rajesh Pawde

EF Code First from Database - Already an object in the database

I'm not sure why but in VB.NET the Code First from Database works fine but in C# this does not work correctly for EF6. ...I decide to let C# create the "dbo.__MigrationHistory" and found that this worked great until I added a new class that was the same name as a table in the database.... This caused the following error: ...The model backing the ...
c# entity-framework entity-framework-6
asked by goroth

EF Code First CREATE DATABASE permission denied in database 'master'

I found my solution....I have 4 project in the solution. but when I try to update-database, the web project does not set as start up project. so I set this project to start up project and I can update-database.
asp.net-mvc-4 c# code-first entity-framework-6 sql-server
asked by masoud noursaid

How to create ASP.net identity tables in an already created database using code first?

So after a bit of reading a fiddling i got the answer. All I had to do was finally run the register method from ASP.NET Identity and all the tables were created.
asp.net asp.net-identity c# entity-framework
asked by LeRainman

EF Code First with existing database on another database

OK, you have 2 databases - let's say DEV and PROD. Both are in an identical state and have the same schema before migrations have been enabled. This is what to do:...1 - Add migrations to your DEV environment and set your database initializer to ...MigrateDatabaseToLatestVersion.... Another option is to ...programatically run migrations.......enabl...
c# ef-migrations entity-framework-6
asked by Steve Greene

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow