O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required