February 23, 2008 at 12:35 pm
Hi All,
My OS=Windows Vista Home Premium and I installed Sql Server 2005.
I can't create a new database.
What can I do??
Kind regards..
Ayşegül
Here is error message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'a'. (Microsoft.SqlServer.Express.Smo)
------------------------------
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
------------------------------
February 23, 2008 at 1:15 pm
I have what I think is the exact same setup at home (Home Premium and Express), and I was able to create "a" 😉 database with this command:
CREATE DATABASE a
Could it be a permission issue?
SELECT has_perms_by_name(null, null, 'CREATE ANY DATABASE');
SELECT has_perms_by_name(null, null, 'CREATE DATABASE');
SELECT has_perms_by_name(null, null, 'ALTER ANY DATABASE');
On my install, I'm an admin and had the CREATE ANY DATABASE right. If this isn't it, then the next place to look is file system rights for the user the service is running as in the folder the database is being created in.
Good Luck!
Chad
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply