Confuses SQL Server Express when creating a new database

I am the administrator of my own machine, I have SQL Server Express installed. But when i tried to create a new database i got this error

Create database permission on database "master"

enter image description here

I realized that I was missing the "sysadmin" role for my login. When I tried to add myself as "sysadmin" I got another error

The user does not have permission to perform this action.

enter image description here

I am the administrator of this machine, why don't I have permission to create a new database on this instance of SQL Server Express?

thank

+3


source to share


2 answers


This post might also be helpful. It points to a script that allows you to add yourself to the sysadmin role (assuming you are the local Windows administrator).



Update As you remove the reference to the actual script, refer to StackExchange's answer on How to Take Responsibility for SQL Server .

+6


source


I would look at this post. http://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx



There are system level rights and then there are SQL rights, sometimes they don't align.

0


source







All Articles