CREATE DATABASE permission denied in database master EF code-first

Question

I use code-first in my project and deploy on host but I get error     CREATE DATABASE permission denied in database  master     This is my connection string    lt add name  DefaultConnection        connectionString  Data Source   SQLEXPRESS Initial Catalog aspnet-test-2012615153521 Integrated Security False        providerName  System Data SqlClient User ID test Password test   gt

User · Answer

Run Visual Studio as Administrator  it worked for me

User · Answer

run this on your master database ALTER SERVER ROLE sysadmin ADD MEMBER your-user    GO

User · Answer

The solution that worked for me was to use the Entity Framework connection string that is created when I ran the database first wizard when creating the edmx file  The connection string needs the metadata file references  such as  metadata res    PSEDM csdl res    PSEDM ssdl res     PSEDM msl   Also  the connection string needs to be in the config of the calling application   HT to this post for pointing me in that direction  Model First with DbContext  Fails to initialize new DataBase

User · Answer

Permission denied is a security so you need to add a  quot User quot  permission    Right click you database which is  mdf file  and then properties Go to security tab Click Continue button Click Add button Click Advance button Another window will show  then you click the  quot Find Now quot  button on the right side  On the fields below  go to the bottom most and click the  quot Users quot   Click OK  Click the permission  quot Users quot  that you have been created  then Check the full control checkbox   There you go  You have now permission to your database  Note  The connection-string in the above questions is using SQL-server authentication  So  Before taking the above step  You have to login using windows-authentication first  and then you have to give permission to the user who is using sql-server authentication  Permission like  quot dbcreator quot   if you login with SQL server authentication and trying to give permission to the user you logged in  it shows  permission denied error

User · Answer

Check that the connection string is in your Web Config   I removed that node and put it in my Web Debug config and this is the error I received   Moved it back to the Web config and worked great

User · Answer

I m going to add what I ve had to do  as it is an amalgamation of the above  I m using Code First  tried using  create-database  but got the error in the title  Closed and re-opened  as Admin this time  - command not recognised but  update-database  was so used that  Same error   Here are the steps I took to resolve it   1  Opened SQL Server Management Studio and created a database  Videos   2  Opened Server Explorer in VS2013  under  View   and connected to the database   3  Right clicked on the connection -  properties  and grabbed the connection string   4  In the web config I added the connection string      lt connectionStrings gt   lt add name  DefaultConnection    connectionString  Data Source MyMachine Initial Catalog Videos Integrated Security True  providerName  System Data SqlClient      gt     lt  connectionStrings gt    5  Where I set up the context  I need to reference DefaultConnection   using System Data Entity   namespace Videos Models   public class VideoDb   DbContext       public VideoDb             base  name DefaultConnection                     public DbSet lt Video gt  Videos   get  set          6  In Package Manager console run  update-database  to create the table s    Remember you can use Seed   to insert values when creating  in Configuration cs           protected override void Seed Videos Models VideoDb context                    context Videos AddOrUpdate v   gt  v Title              new Video     Title    MyTitle1   Length   150                new Video     Title    MyTitle2   Length   270                           context SaveChanges

User · Answer

Run Visual Studio as Administrator and put your SQL SERVER authentication login  who has the permission to create a DB  and password in the connection string  it worked for me

User · Answer

Step 1  Disconnect from your local account   Step 2  Again Connect to Server with your admin user   Step 3  Object Explorer -  Security -  Logins -  Right click on your server name -  Properties -  Server Roles -  sysadmin -  OK  Step 4  Disconnect and connect to your local login and create database

User · Answer

I have no prove for my solution  just assumptions   In my case it is caused by domain name in connection string  I have an assumption that if DNS server is not available  it is not able to connect to database and thus the Entity Framework tries to create this database  But the permission is denied  which is correct

User · Answer

the reason for this error may be originate from forwarding of version dependent localdb in visual sudio 2013 to the version independent localDB in VS 2015 onwards  so  simply change your web config file connectionStrings from  localDb  v11 0 to  localDB  MSSQLLocalDB and it will certainly work  and this is a good explaination for that Version independent local DB in Visual Studio 2015

User · Answer

Create the empty database manually  Change the  Integrated Security  in connection string from  true  to  false   Be sure your user is sysadmin in your new database   Now I hope you can execute update-database successfully

User · Answer

I encountered what appeared to be this error  I was running on windows and found my administrator windows user did not have administrator privileges to database    Shut down SQL Server from    Services         Open cmd window  as administrator  and run single-user mode as local admin with this command  the version of MSSQL may differ      C  Program Files Microsoft SQL Server MSSQL14 SQLEXPRESS MSSQL Binn sqlservr exe  -m -s SQLEXPRESS    Open another cmd window  as administrator  Open sqlcmd on that terminal with     sqlcmd -S   SQLEXPRESS    Now add the sysadmin role to your user    sp addsrvrolemember  domain user    sysadmin  GO    Re-enable SQL Server from    Services      Credit to  https   social msdn microsoft com Forums sqlserver en-US 76fc84f9-437c-4e71-ba3d-3c9ae794a7c4

User · Answer

I had the same problem  This what worked for me    Go to SQL Server Management Studio and run it as Administrator  Choose Security -  Then Logins Choose the usernames or whatever users that will access your database under the Logins and Double Click it  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  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

User · Answer

I got the same problem when trying to create a database using Code First without database approach   The problem is that EF doesn t have enough permissions to create a database for you   So I worked my way up using the Code First using an existing database approach    Steps      Create a database in the Sql server management studio preferably without tables   Now back on visual studio  add a connection of the newly created database in the server explorer  Now use the connection string of the database and add it in the app config with a name like  Default Connection   Now in the Context class  create a constructor for it and extend it from base class and pass the name of the connection string as a parameter  Just like    public class DummyContext   DbContext     public DummyContext     base  name DefaultConnection                  5 And now run your code and see the tables getting added to the database provided

User · Answer

If you re running the site under IIS  you may need to set the Application Pool s Identity to an administrator

User · Answer

This error can also occur if you have multiple projects in the solution and the wrong one is set as the start-up project   This matters because the connection string used by Update-Database comes from the start-up project  rather than the  Default project  selected in the package manager console    credits to masoud

User · Answer

The solution to this problem is as simple as eating a piece of cake This issue generally arises when your user credentials change and SQL server is not able to identify you  No need to uninstall the existing SQL server instance  You can simply install a new instance with a new instance name   Lets say if your last instance name was  Sqlexpress    so this time during installation   name your instance as  Sqlexpress1    Also don t forget to select the mix mode  i e Sql Server Authentication  amp  Windows Authentication  during the installation and provide a system admin password which will be handy if such a problem occurs in future  This solution will definitely resolve this issue  Thanks

User · Answer

I have resolved this problem in my way  Try connection string in this way    lt 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    gt    remember to set default db from master to MFC  in your case  aspnet-test-2012615153521

User · Answer

For me I just close all current session including the SQL Server Management Studio and then I reopened execute the script below works fine   IF EXISTS  SELECT NAME FROM master sys sysdatabases WHERE NAME    MyDb   DROP DATABASE mydb RESTORE DATABASE SMCOMDB FROM DISK    D  mydb bak

User · Answer

As the error suggests  the SQL login has no permission to create database  Permissions are granted when the login have the required roles  The role having permission to create  alter and drop database is dbCreator  Therefore it should be added to the login to solve the problem  It can be done on SQL Management Studio by right-clicking the user then go to Properties Server Roles  I encountered the same error and resolved it by doing exactly that

User · Answer

Double check your connection string  When it points to non-existing database  EF tries to create tables in master database  and this error can occur  In my case there was a typo in database name

User · Answer

I had the same problem and I tried everything available on the internet  But SSMS RUN AS ADMINISTRATOR work for me  If you still face some issue  make sure you must have  downloaded the SQL SERVER

User · Answer

Be sure you have permission to create db  as user2012810 mentioned    or  It seems that your code first use another  or default  connection string  Have you set connection name on your context class   public class YourContext   DbContext               public YourContext     base  name DefaultConnection                                 public DbSet lt aaaa gt  Aaaas   get  set

[code-first] CREATE DATABASE permission denied in database 'master' (EF code-first)

Examples related to code-first