Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

create table permission denied in database 'master'

Tags:

sql

sql-server-2008

sql-server-express

I have installed the free version of sql server 2008 (sql server management studio express edition) on my PC. After installation I get the following error

create table permission denied in database 'master'

I tried reinstalling several times, but I keep getting the same error. When i checked 

select user_account();

It showed that I was logged in as guest. How do I solve this? since I am not permitted to create a new login.

like image 784
user1212 Avatar asked Sep 05 '11 22:09

user1212

People also ask

Can we create table in master database?

You can create a new table, name it, and add it to an existing database by using SQL Server Management Studio or Transact-SQL.

How do I fix create database permission denied in database master?

Step 2: Right click “Login” and select the user account under which you want to create the database. Step 3: Right click and select properties tab. Step 4: Under “Server Roles” tab, select “dbcreator” checkbox. Step 5: Click “OK” and try to create database in the user account.

1 Answers

I've read the error can be caused by UAC (on older versions of SQL Server Express). Try right-clicking on SQL Studio and running as administrator.

If that doesn't work there's supposedly a fix here for the same issue. Probably worth a try.

Script to add the current user to the SQL Server 'sysadmin' role

like image 115
TheCodeKing Avatar answered Sep 22 '22 05:09

TheCodeKing
Sign in to Comment

Related questions

Do I need an else clause in a case expression?
Why Find method generates a TOP(2) query?
how to assign cte value to variable
SQL most recent using row_number() over partition
How do I list all the column names in Netezza?
Temporary table postgresql function
Check if a string contains only number
Create the SQL query "SELECT * FROM myTable LIMIT 10" using dplyr
SQL IsNumeric Returns True but SQL Reports 'Conversion Failed'
List of Best Practice MySQL Data Types
EntityFramework Procedure or function '' expects parameter '', which was not supplied
Return order of MySQL SHOW COLUMNS
How do I return ALL columns in one table and just a few in another using join?
sql search on fields containing diacritics
Performing a bitwise sum
openrowset for excel: can we skip several rows?
SQL: Count number of columns in all tables, excluding views
Count number of rows that are not within 10 seconds of each other
Using a SELECT statement within a WHERE clause
View SQL prepared with sp_prepare

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!