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"
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.
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
source to share
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 .
source to share
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.
source to share