installing sql server 2005 express edition | SQL Server Performance Forums

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.
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?
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…
Moderator 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 from to get more information,. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.