CREATE DATABASE permission denied in database ‘master’ (EF code-first)

by

I had the same problem. This what worked for me:

  1. Go to SQL Server Management Studio and run it as Administrator.
  2. Choose Security -> Then Logins
  3. Choose the usernames or whatever users that will access your database under the Logins and Double Click it.
  4. Give them a Server Roles that will give them credentials to create database. On my case, public was already checked so I checked dbcreator and sysadmin.
  5. Run update-database again on Package Manager Console. Database should now successfully created.

Here is an image so that you can get the bigger picture, I blurred my credentials of course:enter image description here

More Related Contents:

  1. How to disable migration in Entity Framework 4.3.1?
  2. Entity Framework Code First – two Foreign Keys from same table
  3. The model backing the context has changed since the database was created
  4. Why use ICollection and not IEnumerable or List on many-many/one-many relationships?
  5. Unique Constraint in Entity Framework Code First
  6. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  7. ASP.NET MVC3 and Entity Framework Code first architecture
  8. Entity Framework DateTime and UTC
  9. Does Entity Framework Code First support stored procedures?
  10. Entity Framework Code First – No Detach() method on DbContext
  11. Fluent API, many-to-many in Entity Framework Core
  12. Can you create sql views / stored procedure using Entity Framework 4.1 Code first approach
  13. Understanding ForeignKey attribute in entity framework code first
  14. Using MySql with Entity Framework 4 and the Code-First Development CTP
  15. Entity Framework CTP 4 – Code First Custom Database Initializer
  16. How can I disable code first migrations
  17. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  18. Oracle.ManagedDataAccess.EntityFramework – ORA-01918: user ‘dbo’ does not exist
  19. Entity Framework – Is there a way to automatically eager-load child entities without Include()?
  20. SQL Server Express connection string for Entity Framework Code First
  21. Self-referencing many-to-many recursive relationship code first Entity Framework
  22. EF4 Code First: how to add a relationship without adding a navigation property
  23. Entity Framework Database.SetInitializer simply not working
  24. Entity Framework Code First Date field creation
  25. How do I use Entity Framework in Code First Drop-Create mode?
  26. Nullable property to entity field, Entity Framework through Code First
  27. How do I remove underscore of foreign key fields in code first by convention
  28. Change foreign key constraint naming convention
  29. Entity Framework Code First Many to Many Setup For Existing Tables
  30. How to remove child one to many related records in EF code first database?

Leave a Comment