"Database creation is allowed only in the main database" when I entered the main database on the Azure Management portal

Question

I wanted to get the grand CREATE DATABASE permission inside my SQL Azure Server for a specific user. I went to windows.azure.com, logged in, selected "Database" in the left pane, registered in the "main" database as the database administrator, selected "New query" - a window appeared with the heading master: Query(Untitled1.sql) .

I typed

GRANT CREATES A DATABASE IN TATUSERVINE;

and click "execute" and the query result

CREATE DATABASE permission can only be granted in the main database.

What am I doing wrong? How can I do it?

Answer 1

Try

 USE master GO GRANT CREATE DATABASE TO THATUSERLOGIN 

If this does not help, try looking at the management databases and logins in the Azure SQL Guide:

http://msdn.microsoft.com/en-us/library/windowsazure/ee336235.aspx