"CREATE DATABASE permission denied" error

Question

I have installed SQL SERVER 2008 R2 on my system with Windows XP operating system installed.

Whenever I try to create a new database it displays an error:

CREATE DATABASE PERMISSION DENIED IN DATABASE 'master'.(Microsoft SQL Server, Error:262)

When you installed it, there was a page where you specified who should be sys admins for the instance. It doesn't sound like you used the right options (one of them was to `Add Current User`) (unless this is Express) — Damien_The_Unbeliever, Jan 31 '13 at 15:20
@CodeUnderflow - Do you have the password for the 'sa' user? This would have been something configured when you installed SQL Server with SQL Authentication mode. — SchmitzIT, Jan 31 '13 at 16:17

score 4 · Answer 1 · answered Nov 08 '13 at 19:29

4

When you start SQL server management studio use 'sa' user and not Windows-User. Looks like Windows-user does not have permission.

answered Nov 08 '13 at 19:29

user2970263

41
1

score 4 · Answer 2 · answered Dec 03 '15 at 08:20

4

Right-click and run "SQL Server Management Studio" as administrator.

answered Dec 03 '15 at 08:20

Brian

41
1

score 3 · Answer 3 · answered Jan 31 '13 at 12:25

3

Try to grant the user your loged in the CREATE ANY DATABASE Permission then try again. Take a look at the documentation about creating a new Database

answered Jan 31 '13 at 12:25

CloudyMarble

36,908
70
97
130

if that user is unable to grant permission to the user I have logged in then? – LogicalDesk Jan 31 '13 at 12:51
You need to log in with the Admin user to grant this User the needed Permission, this depends on the Option you choosed when you installed the Server, you can use a Windows authentication or a SQL Server one where you provide the Username and Password, this User should be used. – CloudyMarble Jan 31 '13 at 13:04

score 2 · Answer 4 · answered Sep 23 '15 at 19:25

2

Cause of this error is insufficient permission. Give the user "dbcreater" role

answered Sep 23 '15 at 19:25

Ahmet Arslan

5,380
2
33
35

2

May I ask about how to go this Screen? Thanks. – Eng Soon Cheah Nov 08 '16 at 02:01
Server->Security->Logins and choose your user with right click. – Ahmet Arslan Nov 08 '16 at 12:31

Ram-25 · Answer 5 · 2022-04-05T07:18:06.007

1

Check it: SqlSever>>Security>>Logins>>BUILTIN\Users rightClick -->Properties -->Server Roles ...select sysadimn

edited Apr 05 '22 at 07:18

answered Apr 04 '22 at 12:04

Ram-25

11
3

score 0 · Answer 6 · edited May 23 '17 at 12:32

If you are in a situation where you have public/view only access to a SQL database you should consider the following:

Do you have an alternate login or the sa user login credentials? If so, try this first and, if necessary, grant your other login sufficient privileges via the Security/Logins/.. section of your database in the Object Explorer panel (see Ahmet Arslan's answer).
If you have account access to another Windows user who has access via Windows Authentication, try running ssms.exe as the other user via the "runas" command. Full details and explanation here in the answer from SqlRyan.
If you have old databases from a previous Windows installation that had been configured with Windows Authentication (and you do not have/remember the sa account credentials). In this situation, you can recreate your past user account from your previous Windows installation. Be sure this new account has the same Domain and Username as your previous account. Login via the recreated account, and give your current (or "real") user account sufficient permissions (see #1. above). Once you confirm that you have restored access, you can then delete the recreated user account.

score 0 · Answer 7 · answered Feb 01 '17 at 19:43

0

With this problem, I noticed I was connected using Windows Authentication. I then disconnected and used SQL Server Authentication. It is good now.

answered Feb 01 '17 at 19:43

Baqer Naqvi

6,011
3
50
68

First time user. when I do SQL Server Authentication it is asking username and password. Any idea what is the default username/password? – william cage Jul 04 '17 at 22:25
@williamcage SQL Server 2008/R2 Express User: sa Password: [blank password - leave field empty to connect] SQL Server 201x Express User: sa Password: Password123 SQL Server 20xx Web or Standard User: sa Password: will be the same as your administrator or root user password at the time the VDS was provisioned. – Baqer Naqvi Jul 05 '17 at 11:38

score 0 · Answer 8 · answered Aug 13 '22 at 13:37

0

first you will login on windows authentication then you will click on login (sa) properties and server role check in db creater then ok click then error is solved and after login within sa and create a database

answered Aug 13 '22 at 13:37

Ahsan Raza Alvi

49
3

"CREATE DATABASE permission denied" error

8 Answers8

Linked