sql server developer edition - SQL Server Forums

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

sql server developer edition

Author

Topic

theGodFather
Starting Member

1 Post

Posted - 2007-10-05 : 17:22:04

i am using sqlserver developer edition on windows vista home premium and i can not create new database the message says :
TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Database 'mm'. (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.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

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

OK
------------------------------
i don't have permession to create the database i am administrator and i dont have permesion what to do now

thanx

Haywood
Posting Yak Master

221 Posts

Posted - 2007-10-05 : 17:48:16

Did you run the Vista Provisioning tool at the end of SQL setup?

Is SQLServer supported on Vista Home Edition? I don't know if it is or not, I'm not using ANY variation of Vista, I have work to do. ;)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-05 : 22:46:09

Local admin doesn't necessary have proper sql permission, connect to sql with sysadmin id then create db.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources