Impersonate to Create Database

[cuctitanium]

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!

[rmiao]

What kind of sql permission does that windows accoung have? Is it in any server role?

[mikr0s]

Database creation is a server level permission, so you have to impersonate the login and not the database (master) user.

EXECUTE AS LOGIN = 'Domain\uid';

--HTH--