Create database permission denied in database master
First , login as an admin user- then try executing this script.
USE master;EXECUTE sp_addsrvrolemember @loginame = N'MyWindowsDomain\MyUserName', @rolename = N'dbcreator';
If this doesn’t do it, find this LOGIN under the SECURITY\Logins tab (in Management Studio). Right Click ‘Properties’. See Server Roles – and check SYSADMIN. That should give you all the roles of a sysadmin.
Leave a Reply