CODEWITHSUNDEEP
sql-serversql-server-2008ssms
Mark Tait
Mark Tait

Reputation: 643

Cannot create a new database in Sql Server - changed username

I installed Sql Server on a server in a company I used to work for.

I left the company - and rejoined a year later - and now I have a different domain login.

I've logged on to the server again, and in SSMS tried to create a new database - however I get the error:

create database permission denied in database 'master'

I have tried changing permission and adding DBCreator to BuiltInUsers and to SA - and also tried adding my new domain name to the security section - but when I try to add DBCreator to my user name, I get the error:

Cannot alter the server role 'dbcreator' because it does not exist or you do not have permission

Is there any way I can take control of the Sql Server instance again, to allow me to create new databases?

Thanks for any help,

Mark

Upvotes: 1

Views: 693

Answers (1)

Elham Beydaghi
Elham Beydaghi

Reputation: 33

I faced this problem when I made another SQL user which I login with, and I tried to give this user [dbcreator] grant.

I solved this via

  1. runnig sql server as administrator
  2. switching to my windows authentication.
  3. going to folder Security -> Logins and double click on my new sql login user.
  4. selecting Server roles and give grant to my user.

Upvotes: 0

Related Questions