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.

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written 1216 posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.

---