installing sql 2005 express edition

• karina kapur

  SSC-Addicted

  Points: 445

  More actions

  April 30, 2007 at 6:41 pm

  #195435

  Hi,

  I have installed my SQL SERVER 2005 Ex Ed on my SERVER.

  From my machine I can connect to the SQL SERVER.

  But when I try to CREATE a DB I get the following error:

  Create failed for Database 'Test'

  Additional Information:

  An exception occured while executing a Transact-SQL statement or batch.

  (Microsoft.SQLServer.Express.ConnectionInfo)

  CREATE DATABASE permission denied in database 'Master'. (Microsoft SQL Server, Error: 262)

  When I look in my Object Explorer and on expanding Databases I see

  master which can be expanded

  model which can be expanded

  msdb which can be expanded 

  So when I right click on Databases and select new Database and put in 'Test'

  I get the above error.

  and I am not in the master DB.

  I am using the Free version of SQL 2005 Ex Ed.

  Could that be a problem?

  Tnx

• jezemine

  SSCrazy Eights

  Points: 8059

  More actions

  May 5, 2007 at 10:21 am

  #704513

  sounds to me like the login you are using to connect doesn't have permissions to create databases.

  ---------------------------------------
  elsasoft.org