"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 launch my development environment's default database as soon as possible.

What is the most straightforward solution to this issue?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I've had this issue before and found a solution. Using SQL authentication rather than Windows' is crucial. The best approach to set the default database is in this manner.

Try the following connection string:

<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" />

Keep in mind to set the integrated security parameter to false and the default database of the SA to MFC. Aside from that, sa is often deactivated, so turn it on 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 recently encountered this issue. Your DbContext subclass's class name must precisely correspond to the connection string's name. If it doesn't, EF won't be able to locate the connection string and will attempt to fall back to an other method (SQL embedded? ), which is ineffective on my computer (I have full SQL Server installed).
entity-framework
asked by jlew

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

Simply omit the "create database" step and employ the migrations independently. On ...GitHub..., I've posted a sample project, however the crucial information 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

In addition to what @David previously said......Personally, I have no faith in...automatic updates... I always prefer manual database management in "live" settings (that is, if there is an issue with...permissions... to construct or modify a database is required, not to mention shared hosting, etc.) - However, based on my experience, migrations are...
asp.net-mvc c# entity-framework
asked by NSGaga-mostly-inactive

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

Throw the bool param Because the asp.net Identity model has changed, IfV1Schema throws an exception (updated to new version 2)....For a single migration, modify your IdentityDbContext constructor:...public YourDbContext() : base("YourConnectionString", throwIfV1Schema:false){}
asp.net-identity entity-framework
asked by Arvis

Code First Existing Database vs EF Designer to Existing Database

ZZZ_tmp
entity-framework
asked by JotaBe

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

ZZZ_tmp
.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

ZZZ_tmp
c# entity-framework entity-framework-6
asked by goroth

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

I figured it out....In the solution, I have four projects. However, the web project is not configured as a start up project when I attempt to update the database. I thus configured this project to launch so that I may update the 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 some reading and fumbling, I discovered the solution. All the tables were generated once I finally executed the register function from ASP.NET Identity.
asp.net asp.net-identity c# entity-framework
asked by LeRainman

EF Code First with existing database on another database

Let's imagine you have two databases, DEV and PROD. Before migrations are enabled, both are in the same state and share the same schema. What you should do is:...1 - Set your database initializer to ...MigrateDatabaseToLatestVersion... and add migrations to your DEV environment. The alternative is to ...run migrations systematically.......enable-mi...
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