Wednesday, December 3, 2008

Creating a new database with Sql Server Managment Studio Express

If you get thhis error then try this

CREATE DATABASE permission denied in database 'master'.

If the current user does not have the admin permission.Please refer to the following suggestion . Open Microsoft SQL Server 2005 -> Management Studio Express Edition , right click Management Studio Express Edition and choose Run as Administrator to connect SQL Server with your administrator,select Security->Logins ,then double-click the user account you want to fix , select Server Roles section and check sysadmin check box, click OK to save it. You can also open Microsoft SQL Server 2005-> Configuration Tools-> SQL Server Surface Area Configuration with your current user, click Add New Administrator ,double-click the Member of SQL Server SysAdmin role on yourinstantname in Available priviledges , click OK to save it.
Hope this helps.

No comments: