Create Database permisison denied

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create Database permisison denied

Author

Topic

mustafabrew
Starting Member

1 Post

Posted - 2007-09-27 : 15:13:26

Hi, I'm new to SQL. I've installed visual studio and SQL server management studio express.

I want to create a new database but I get the following error which I can't get past.

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

Create failed for Database 'intranet'. (Microsoft.SqlServer.Express.Smo)

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

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

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

Any suggestions? I am logged in with my account which is an adminstrator account and the same that I installed the software under.

Thanks,

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-27 : 23:47:35

Do you have permission to create db in sql instance?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources