Creating database error

Question

I've just installed MSSQL 2005 Express and Managment Studio

When I tried to create my first database in MS SQL 2005 Express, I get the following error, 'Create database permission denied in
database 'master''(error 262). I set the security to Windows Authentication. Is there a selection I did not make correctly during installation. Can't seem to find any helpful information in the help menu.
Thanks

Answer 1

Hi,

to Grant Administrative Rights on SQL Express 2005?

1. Open SQL Server Surface Area Configuration Application ( Start --> All Programs --> Microsoft SQL Server 2005 --> Configuration Tools -->SQL Server Surface Area Configuration)
2. Click on Add New Administrator
3. A new window with title 'SQL Server User Provisioning on Vista' popup and displays the permissions on the left panel.
4. Select the permission 'Member of SQL Server SysAdmin role on SQLEXPRESS' available on the left panel and add it to the right panel with the help of add button( button with > text) available in the window.
5. Click on OK button to save the changes.
6. That's all now your Windows login has administrative privileges on SQL Server.

---

Best Regards, Ammar MCT