Create Database failed in SQL Server 2008

Check out: https://www.experts-exchange.com/questions/27665353/Adding-Logon-to-SQL-Express-Database.html

You dont have sufficient permissions to create the database, being part of the windows admin group is not equivalent to sql server sysadmin group, some one with sysadmin permission on sql srever should grant you the permission(in your case, you probably need the sa password.).

http://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx

Hi Experts,

I am already having windows login . I am able to authenticate. So, for that user i have to grant sysadmin role.

But my problem is i don't have sa password and even i tried to login with Administrator account  and grant the sysadmin role. Still i am getting the error message as "user does not have permission to perform this action "

My question . why i am gettin that erro even whne i logged in as administrator. what all needs to be verified that the user Administrator.

Hope that i have asked the question correctly ..

Thanks
Chanikya.

I hope this is not a stupid suggestion, but have you tried if you can start the Management Studio with "Run as administrator" (right click on the icon in the start menu). And then just look up the user you want under Security-Logins at the main level, and in the Properties at Server Roles add 'sysadmin' manually?

It must be possible one way or the other because I don't have the sa password on my machine at work and have done this myself (adding my domain user instead of administrator) and was able to create databases afterwards.

Hi Robert,

Thank you for reply.. The SQL Server installed already in that machine. But Recently my login added to that machine as Admistrator. I do not see my login in SQL Server login section.. Even i am not able to change myself as sysadmin.

I am getting the error message as  "The user does not have permission to perform this action"

Thanks
Chanikya.

Hi Expert.

Is that possible that domain admin account without  sysadming role. ?



Thanks
Chanikya.

Yeah, I guess that's possible. If you're not able to find that out in Management Studio (even using 'Run as Administrator') that's probably the best proof you just have too few permissions. In that case I don't really see how we can help you, better get the person who installed it on your machine to explain what the meaning is, how they want you to use it, maybe only use existing databases? In my experience smart system administrators give you enough permissions so that you can do what you need to do so that you don't have to bother them each time you need something ;-) but maybe it's different in your environment.