Error while creation database in sqlserver2005

• chandu_cs24

  SSC Rookie

  Points: 43

  More actions

  March 18, 2010 at 3:43 pm

  #63880

  ERROR COMING LIKE THIS WHILE I WAS TRIED TO CREATE A NEW DATABASE AFTER INSTALLING SQL SERVER 2005..CAN ANYBODY CLEAR MY ERROR?

  TITLE: Microsoft SQL Server Management Studio Express

  ------------------------------

  Create failed for Database 'CHANDU'. (Microsoft.SqlServer.Express.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.Express.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.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

• GTR

  SSCrazy Eights

  Points: 8007

  More actions

  March 18, 2010 at 4:19 pm

  #1136360

  User doesn't have permission to create database, what role did you assign to this user?

  EnjoY!