Login Failed for user '.' in Azure Synapse workspace portal

Lordan Liu 1 Reputation point
2020-11-25T02:20:37.7+00:00

I have SQL admin permission, but when i access a table in a database, I still got Login failed error message in Azure Synapse workspace. any idea how to fix the issue?
42441-2020-11-25-09-56-22-asajgpcdp401-azure-synapse-ana.png

42393-2020-11-25-10-02-20-synapse-table-accesspng-paint.png

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.
2,847 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee
    2020-11-27T05:27:11.73+00:00

    Hello @Lordan Liu ,

    Welcome to the Microsoft Q&A platform.

    Currently, the Access control within Synapse Studio does not apply to dedicated SQL pools. Workspace admin can create a user manually through T-SQL or they can add you through SQL Active Directory Admin option when they navigate to workspace resource in Azure Portal.

    Hope this helps. Do let us know if you any further queries.

    ------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.