Problem with creating a new database

Question

Post reply

Problem with creating a new database

aysegul

Right there with Babe

Points: 778
More actions
February 23, 2008 at 1:03 pm

#122264

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)
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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

please don't xpost, many of us watch more than one forum group.

Might get somewhat confusing 😉

- Did you install SQLexpress mgmt studio ?

- did you apply the servicepacks ? (on both)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Animal Magic SSChampion Points: 13964 More actions · Answer 2

It seems your issue is to do with the permissions of the user your using to create the DB. As vista is different than XP,2000 in that the local admins are not SA on a sql instance you need to make a few changes.

Install SP2 and at the end it will ask if you want to launch the Vista user provisioning tool, that will allow you to add the required users as Sysadmin. Then using that account you will be able to create a new DB.

aysegul Right there with Babe Points: 778 More actions · Answer 3

these are the my SQL Server informations.

Microsoft SQL Server Management Studio Express 9.00.3042.00

Microsoft Data Access Components (MDAC)6.0.6000.16386 (vista_rtm.061101-2205)

Operating System6.0.6000

I install SP2.

There is any problems between Visual Studio and Vista.

Vista directs me what I have to do and I install SP1 to fix these for Visual Studio

and SP2 for SQL Server 2005

I can't open model database.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

did you move database files ?