CREATE DATABASE Permission Denied in Database ‘master’? Not Any More!

In Vista environment, when you run Microsoft SQL Server Management Studio Express and try to create a new database on your local instance (MACHINENAME\SQLEXPRESS), you might get the following error:

CREATE DATABASE permission denied in database ‘master’

The reason is; you are connecting to the database using Windows Authentication. If you start Management Studio Express the regular way, the program won’t have any Administrator privileges which are required to be able to create a new database.

You simply have to run Management Studio Express as administrator. Here is a step-by-step guide:

  • Close Management Studio Express
  • In the start menu, right-click the shortcut of Management Studio Express and select “Run As Administrator”
  • If Windows asks if you want to allow the program in admin mode, say “Yes”
  • Retry creating your database
  • Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s