Setting password for contained users mapped to Azure AD identities

Neil Pereira 81 Reputation points
2020-09-17T19:52:11.627+00:00

Hi,
I'm implementing Azure Active Directory Authentication for users to get in and use Synapse Analytics (SQL DW).
I have 2 questions they are as follows:

  1. The Azure AD method that I used was Azure Active Directory Password.
    Through this, I had the credentials of AD Admin ie me, and was hence able to log in via SSMS. Then, I created a contained user while mapping to Azure AD Identities, link shared below.
    Query: CREATE USER <Azure_AD_principal_name> FROM EXTERNAL PROVIDER;
    https://video2.skills-academy.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell#create-contained-users-mapped-to-azure-ad-identities Again, I'm curious to know, that does Synapse Analytics support contained user in AD Authentication, and if yes, how can this user/ principle log in?
    As, in my last post it was discussed and confirmed that Synapse doesn't support contained user via SQL Authentication. Wasn't sure about AD Authentication.
  2. My role in the above instance is AD Admin and I logged in using the Admin credentials.
    What if I make one of my AD Group as the Admin, which I can, but I'm curious how will this group log in to SSMS? as I'm not sure if a group can have a password as an individual user ?

Thanks,
Neil.

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,631 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2020-09-18T03:58:37.127+00:00

    Hi @neil ,

    Please refer to the following links:

    Authenticate to Azure Synapse Analytics

    Connect to the SSIS Catalog (SSISDB) in Azure

    Best Regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2020-09-21T18:05:18.25+00:00

    Hi @Neil Pereira ,

    In addition to above information, I would also like to share couple of other helpful resources related to your query.

    Hope this helps. Please let us know if you have further query.

    ----------

    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.