creating a new database in sql server 2005

SirReadAlot
SirReadAlot used Ask the Experts™
on
Hi Experts,

I am trying to create a db by doing this
1)iexpanded the object browser
2)right-clicked on database folder
3)create new db appears
4)filled in the necessary textboxes
5)clicked okay

then i recieved

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Database 'estates'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&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.4035&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

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

OK
------------------------------
does this mean that IT have not proved me with full permissions?

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009
Commented:
are you sure you got the "create database" permission
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
>CREATE DATABASE permission denied

seems obvious to me?!
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
full answer: the login you are connecting with lacks some powers.

check out which server roles that login has:

Fixed roles
The fixed server roles are applied serverwide, and there are 2 predefined server roles to allow this function:
    * SysAdmin: Any member can perform any action on the server.
    * DbCreator: Any member can create, alter, drop, and restore databases.

Author

Commented:
.

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