SQL Server 2008 Express permissions problem

Rick Danger
Rick Danger used Ask the Experts™
on
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
------------------------------
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
On the server/workstation that you installed SQL Server, are you an administrator?

Greg

Top Expert 2011

Commented:
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.

Author

Commented:
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.
Top Expert 2011
Commented:
By the way, I think I know your brother, Alka.

LOL!!

You can either use the account you installed sql server express with to create the table or you use it to create a new account.

To add a new account, in the explorer window, expand the first Security context  you see.

Right-click on Logins
Enter login name

Click on Sql Server authentication mode

enter passord,

confirm it

Once it is accepted,

right-click on it,

Select properties

Select User mapping

tick the database name as well as master database name.

At the bottom, tick dbo owner and I think you should be good to go now.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial