0

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)

anthares
  • 11,070
  • 4
  • 41
  • 61
Jim
  • 1
  • 1
  • 1

2 Answers2

2

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

Furunomoe
  • 1,344
  • 2
  • 16
  • 27
0

Have you tried to create it with the 'sa' user ? Also, check whether your windows user has the proper permission for this database in the sql-server settings.

anthares
  • 11,070
  • 4
  • 41
  • 61