Cannot create database in SQL Server 2012 express

Posted on 2012-09-17
Last Modified: 2012-10-06
I have a fresh install of SQL Server 2012 express I am trying to create a database in and I keep getting the following error:

TITLE: Microsoft SQL Server Management Studio

Create failed for Database   (Microsoft.SqlServer.Smo)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

For help, click:



I tried running SQL Server 2012 Express edition as administrator and I keep getting th error. The steps I have taken to create the database is as follows:

1. Right click databases in the object explorer
2. Click "New Database"
3. Gave the database a name
4. Clicked on OK.

I am running Winodws 7 Pro.

Question by:DB-aha
    LVL 25

    Expert Comment

    Its because you don't have admin priviledge. The a/c you are using is just public role. Following is an article on 2008. Same should apply on 2012 as well.
    LVL 1

    Author Comment

    Sorry, the instructions are a bit difficult, they are written completely in tech speak. Could you break down the steps in something simple to understand?
    LVL 1

    Accepted Solution

    To resolve the issue, I uninstalled and re-installed.
    LVL 1

    Author Closing Comment

    NO other solution was clarified to be able to be used. My solution allowed me full access to the application as intended.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now