iNECTA - Microsoft Navision
Home Portfolio of Products & Services Media Kit About Us Contact Us Blog Go To Meeting Worldwide Partner Portal

Posted by : Jon in (SQL)
July 7, 2009

Create Database permission denied in DB master in sql 2008

Tagged Under : ,

This happens in Vista when you try to create a database in microsoft sql 2008. The reason is that by default the administrator account does not have enough rights.

The solution is to grant rights to the administrator

Step 1: Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.

Step 2: Click on ‘Add New Administrator’.

Step 3: In the ‘SQL Server User Provisioning on Vista’ dialog box, look out for the ‘Member of the SqlServer SysAdmin role ‘ in the ‘Available Privileges’ box. Transfer it to the ‘Privileges that will be granted to’ box. Click Ok.

and at last

Control Panel->User Accounts->Turn User Account Control on or off. turn it off and try again


Google Reader or Homepage

Make a comment