Database Create on SQL Server2008 Express/Windows VIsta Home Edition

sql-server-2008sql-server-expresswindows-vista

I successfully installed Express on Windows Vista Home Edition. When I tried to create a database using the account under which it was installed I received this message:

TITLE: Microsoft SQL Server Management Studio

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

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)

Best Answer

It looks like that you need to add appropiate access to the account first, a quick googling give me this :

http://msdn.microsoft.com/en-us/library/bb326612.aspx

Related Topic