Managing Logins and Users
As mentioned earlier in this chapter, all ASD logins must use SQL Authentication. In addition to not supporting Windows Authentication, a few other ASD restrictions apply: You cannot use an email address as a login or user name, Microsoft user accounts 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 ASD server. At creation time, it is made a member of both the dbmanager and loginmanager roles. In addition, it is also a member of the hidden ...
Get Microsoft SQL Server 2014 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.
