SQL Server 2008 on Windows Vista Home Premium

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 Administration

SQL Server 2008 on Windows Vista Home Premium

Author

Topic

jchasu
Starting Member

2 Posts

Posted - 2010-02-16 : 18:27:56

I installed Express on Windows Vista Home Premium Edition and tried to create a new database using the account under which I installed. I got this message: what do I need to do to give myself permissions to create objects? BTW: No problem like this with SQL Server 2005 or Version 7.

TITLE: Microsoft SQL Server Management Studio------------------------------ Create failed for Database 'Test1'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&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.4053&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

Jim Unger

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-02-16 : 20:10:47

Right click on the Management Studio icon and select "Run as administrator".

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

jchasu
Starting Member

2 Posts

Posted - 2010-02-17 : 19:46:20

Thank you Tara!

Jim Unger

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-02-17 : 23:46:31

You're welcome.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Marky
Starting Member

1 Post

Posted - 2011-06-30 : 20:42:22

You can turn it on to always use administrator as well.
• right click the program
• click properties
• goto compatibility tab
• under privilage level check Run this program as an administrator.

Windows vista problems are very common so I would suggest upgrading to windows 7 if possible.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources