i am trying to create a database in management studio using a query but it is throwing the following error
"CREATE DATABASE permission denied in database 'master"
i have installed sql server express with service pack 2 first and then management studio later.
if i try login on using
machinename\username then how do i give permission to the logged on user??
if i run management studio i am able to create the database but not when i am logged in as a user.how do i give permission to the user??
pls reply ASAP.
you need to login using an account which has administrative permissions in Management Studio.
then you can add user to 'db_creator' server role, which will enable user to create database
Try to login with Sys admin or Security admin privilaged user. Try to login with sa account.
Otherwise try to login in windows authentication using windows level admin privillage user if in case BUILTIN\Admininstrator account is enabled.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?