Brien walks through the steps necessary for authenticating users on-premises and in the cloud with Microsoft's Windows Azure ... SQL Server database is required. Furthermore, if your Active ...

from Azure Active Directory Authentication support to the inclusion of a Data-Tier Application Wizard. The new features were announced by Alan Yu, program manager for SQL Server, in a recent post ...

If you have Windows logins, the login SID in SQL Server will match the SID from Active Directory. So all you need to do is create the same login on both your primary and secondary server.

Microsoft has made available to testers a public preview of its "new" Azure Active Directory Connect tool that is designed to link Windows Server Active Directory to Azure Active Directory.