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.
Wednesday, December 3, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment