Always Get Better

«
»

VISTA: How to fix SQL Server Express Error – CREATE DATABASE permission denied in database ‘master’

If you’re using SQL Server Management Studio Express under Windows Vista and see either of these errors:

CREATE DATABASE permission denied in database 'master'

or

The database [Name] is not accessible. (Microsoft.SqlServer.Express.ObjectExplorer)

Here’s the fix:

  1. Close SQL Server Management Studio Express
  2. Open your start menu and locate that program.
  3. Right-click on the Management Studio and choose ‘Run as Administrator’
  4. Fixed!

I swear the simplest solutions can be the hardest to find – hopefully this saves someone (or my forgetful self!) some aggravation.

Tags: , , ,

This entry was posted on Thursday, November 5th, 2009 at 8:22 am and is filed under SQL, Windows Vista. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “VISTA: How to fix SQL Server Express Error – CREATE DATABASE permission denied in database ‘master’”

  1. alaska_tech says:
    February 28, 2011 at 3:54 pm

    Dude,
    I cannot believe this was the fix I needed. Nice.

Leave a Reply