Dear all,

I have sysadmin role. I am testing a Windows Logo to see if it can create database sucessfully. However, I'm getting an error saying: CREATE DATABASE permission denied in database 'master'.

Here is the scripts I ran:

USE Master;
EXECUTE AS USER = 'Domain\uid';
Create Database test;

How come I am getting permission deined? I queried the system view. This Windows logon does have permission to Create Any Database.

PS: I have issued the following statements to the server:
REVOKE CONNECT FROM GUEST;
REVOKE VIEW ANY DATABASE FROM public;

Does the error has something to do with these Revoke statements?

Thank you!