Link to home
Start Free TrialLog in
Avatar of Rick Danger
Rick DangerFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL Server 2008 Express permissions problem

TITLE: Microsoft SQL Server Management Studio
This will be easy for somebody who understands this sort of thing. I've just installed SQL Server Express 2008 and trying to create a test database, but get this.
------------------------------
Create failed for Database test'.  (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&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+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

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

OK
------------------------------
Avatar of JestersGrind
JestersGrind
Flag of United States of America image

On the server/workstation that you installed SQL Server, are you an administrator?

Greg

Open up sql server management studio,

on the explorer window, expand databases,

Right-click on Master database

Click on Properties

Click on Permissions

Select the account you are trying to create database with and grant it the Create Permision and any other permission you wish to grant it and it should work.
Avatar of Rick Danger

ASKER

Jester - No!
Mr Seltzer
I only get guest in the list - how do I add a new user?

By the way, I think I know your brother, Alka.
ASKER CERTIFIED SOLUTION
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial