Azure SQL Active Directory Admin not working

  • Hello everyone,
    I'm trying to configure an Azure SQL server with an Active Directory group as an admin account. My company is using Azure AD and the Azure portal allows me to add the AD group.

    However, when I try to connect to the server using SSMS I get an error stating that the version of SQL does not support Windows logins

    My understanding is that Azure SQL version 12 allows for such authentication. When I run SELECT @@VERSION it returns:
    "Microsoft SQL Azure (RTM) - 12.0.2000.8 Mar 30 2017 01:30:03 Copyright (C) 2016 Microsoft Corporation. All rights reserved."

    I'm using SSMS version 13.0.15900.1 - I've tried connecting from a Windows 7 and Windows 10 client machine, though I don't think that has anything to do with it.

    Does anyone have any experience with this?

    Thanks.

    In SQL there are no absolutes, it always depends...

  • I have learned what I was doing wrong. I was attempting to connect using the standard Windows Authentication. In order to connect to an Azure SQL server with an Active Directory account, you need to specify Active Directory Universal Authentication.

    In SQL there are no absolutes, it always depends...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply