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.