it's your site

Web Site Go

You are here :

Article Details

CREATE DATABASE permission denied in database master

I am a microsoft guy, that’s what someone said recently by looking at my profile :S. How does this relate to this article? Yes, I am trying Windows 7 installed on my PC to explore. I always want to explore any new products from microsoft.
Recently, I have installed SQL serrver 2005 Express on my windows 7 operating system and wanted to create a database by using the following SQL statement

CREATE DATABASE SampleDB

But i ended up getting the following error L

Msg 262, Level 14, State 1, Line 1

CREATE DATABASE permission denied in database 'master'.

Ok, what was going wrong?

I tried checking if the service was running with local system account, yes it was.

The solution was launching the management studio as an administrator. So the culprit was my windows 7, i hope in windows vista also this problem should arise, since Vista and Windows 7 use User Account Control (UAC). I never faced this problem in vista since i always disable it.