SQL Server Performance Forum – Threads Archive

installing sql server 2005 express edition

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
and my RCH1 that is not expandable. 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

---

Using version should not be problem…
Looks like you don’t the sufficient permissions to create a database… Make sure either you are either member of ‘sysadmin’ or ‘dbcreator’ server roles…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

As explained it is a permission and privileged based error, ensure you have specified privileges to create. Also download updated Books online fromhttp://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b to get more information,. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

]]>