SQL Server Express CREATE DATABASE permission denied in database master

Question

After I change the option as UserInstance  False   then the error starts to happen   Because I want to use full-text search  the option change is required  BUT  it stopped to work  Is there any way to make it work again    I m running Application Pool as Network Service with full control

User · Answer

What login are you connecting to SQL Server as   You need to connect with a login that has sufficient privileges to create a database   Network Service is probably not good enough  unless you go into SQL Server and add them as a login with sufficient rights

User · Answer

After I performed the following instructions in SSMS  everything works fine   create login  IIS APPPOOL MyWebAPP  from windows   exec sp addsrvrolemember N IIS APPPOOL MyWebAPP   sysadmin

User · Answer

I know  it is an old question  but no solution worked for me  Here is what I did   USE master  GO  GRANT CREATE TABLE TO PUBLIC   Repeat this with every permission you need  for example GRANT CREATE DATABASE TO PUBLIC      You must have the server role  public   yes  I am captain obvious    Note 1  GRANT ALL TO PUBLIC is deprecated  does not work anymore in 2017   Note 2  I tried to build an msi installer using the wix toolset  This toolset calls a powershell file  wich creates the databases      Just to give you some background information

User · Answer

That s because you have selected your Master table on the table drop down Table Selected  Select the table you want to use and proceed executing your query

User · Answer

A solution is presented here not exactly for your problem but exactly for the given error    Start --  All Programs --  Microsoft SQL Server 2005 --  Configuration Tools --  SQL Server Surface Area Configuration Add New Administrator Select  Member of SQL Server SysAdmin role on SQLEXPRESS  and add it to right box  Click Ok

User · Answer

i have same problem  and i try this    log In As Administrator on your PC log In SQL Server Management Studio as  Windows Aunthication  Click Security   Login   choose your login where you want to create DB   right click then Properties   click server roles   then checklist  dbcreator   Close and log in back with your login account    This worked for me  and hope will help you    sorry for my bad english

User · Answer

Solution for Microsoft SQL Server  Error  262  Click on Start -  Click in Microsoft SQL Server 2005 Now right click on SQL Server Management Studio Click on Run as administrator

User · Answer

Download the script from this Microsoft Site Run it as Administrator  Follow the instructions and your set    UPDATE 9 3 2014  The Microsoft URL above is no longer valid  someone thou took the time to save it to GitHubGist and the link is as follows https   gist github com wadewegner 1677788

User · Answer

Addition to  Kho dir answer   This also works if you are not able to create a database with the windows user  you just need to login with the SQL Server Authentication then repeat the process mentioned by  Kho dir

User · Answer

Log into on your Server PC with administrator account Log into SQL Server Management Studio as  Windows Authentication  Click Security -  Logins -  choose your  -  right click then choose Properties or Double click -  click Server Roles -  then checklist  dbcreator  and  sysadmin  then click the OK button  Refresh your databases    Now  you can create new database

User · Answer

If you got the same error in Sql server 2008 management studio than below link will resolve this error after so much effort i found this link  http   social msdn microsoft com Forums en-US sqlexpress thread 76fc84f9-437c-4e71-ba3d-3c9ae794a7c4

User · Answer

For SQL server 2012     First  log in to the SQL server as an administrator and go to Security tab Then move into Server Roles and double click on sysadmin role Now add user which you want to give permission to create Database by clicking Add button  Click  OK button  and now run the query    Hope this will help for someone

[sql-server] SQL Server Express CREATE DATABASE permission denied in database 'master'

Examples related to sql-server

Examples related to sql-server-express