Issue with providing access to a AD group in Azure SQL Database

Nandan Hegde 29,996 Reputation points MVP
2021-02-22T04:21:27.537+00:00

I have a AD group : $(Test)-ActiveMembers.

CREATE USER [$(Test)-ActiveMembers] FROM EXTERNAL PROVIDER;
GO

Executing the above query with AD admin account in Azure SQL database but getting the below error:

'$(Test)-ActiveMembers' is not a valid login or you do not have permission.

Is there any way to execute it directly without having the need to create another AD group?

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,557 questions
0 comments No comments
{count} votes

Accepted answer
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-02-22T05:31:50.433+00:00

    @Nandan Hegde The display name of the AD group should exactly match the value used in the command.
    However, there are limitations on the characters you can use in the name of an AD Group or user.

    Characters allowed

    • A – Z
    • a - z
    • 0 – 9
    • ' . - _ ! # ^ ~

    I tried with # in my AD Group name and was able to create the user without any issues

    70407-image.png

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.


0 additional answers

Sort by: Most helpful