asked on

Cannot create database in SQL Server 2012 express

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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

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: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

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.

Thanks

TempDBA

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.

http://stackoverflow.com/questions/3781365/how-to-change-sa-password-in-sql-server-2008-express

DB-aha

ASKER

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?

ASKER CERTIFIED SOLUTION

DB-aha

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DB-aha

ASKER

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