As mentioned earlier in this chapter, all SQL Database logins must use SQL Authentication. In addition to not supporting Windows Authentication, a few other SQL Database restrictions apply: You cannot use an email address as a login or user name, Microsoft user accounts (formerly Windows Live IDs) are not supported (although you must have one to manage your Azure subscription), and all other custom authentication tweaks (including the use of
LOGON triggers) are unsupported.
The login you are already familiar with is that of the server-level principal (SLP). This is the login you created when you set up your SQL Database server. At creation time, it is made a member of both the