Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Problem creating database using SQL Server Management Express

I am trying to create a database using SQL Server Management Express. The following error occurs:

TITLE: Microsoft SQL Server Management Studio Express

Create failed for Database 'dbTestDBase'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.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.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

like image 784
Furqan Sehgal Avatar asked Feb 26 '23 20:02

Furqan Sehgal


2 Answers

Run Microsft SQL Server Studio as administrator....your problem will be solved

like image 105
MSC Avatar answered May 13 '23 23:05

MSC


It's very clear: the credential you are using doesn't have enough privileges to be able to create a new database. Are you logged in using Integrated Windows Authentication or Sql Server Authentication? Make sure your credentials have the dbcreator role either way.

http://msdn.microsoft.com/en-us/library/ms176014%28v=SQL.90%29.aspx

like image 29
Icarus Avatar answered May 13 '23 23:05

Icarus