dbTalk Databases Forums  

Create database permission denied in database 'master'

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Create database permission denied in database 'master' in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Olav
 
Posts: n/a

Default Create database permission denied in database 'master' - 04-17-2007 , 03:42 PM






Hi,
i am creating an installation program which first installs SQL Server 2005
Express Edition with SP2. Then it executes a CREATE DATABASE statement which
generates the in Subject mentioned 262 error. I get the same error if i try
to create the database in Management Studio. The computer is running Vista.
Is it correct that SQL Server 2005 Express Edition with SP2 have version nr,
9.0.3042?

Olav

Reply With Quote
  #2  
Old   
Deepanshu Garg
 
Posts: n/a

Default Re: Create database permission denied in database 'master' - 04-22-2007 , 07:24 PM







Olav,
You can use the provisioning tool which comes with SQL Server 2005
Express edition located at
C:\Program Files\Microsoft SQL Server\90\Shared\sqlprov.exe

Clicking this link should launch the provisioning tool and allow you to
specify the user you want to add to the SysAdmin role

This will allow you to create the databases.
For addditional information please visit this
site
http://blogs.msdn.com/sqlexpress/
Thanks



*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.