Managing Logins and Users
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.
Managing Logins
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 dbmanager and loginmanager ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
