Share via

How to access Lake database tables in SSMS through SQL auth which are created through Synapse Notebooks

Srikanth Thota 6 Reputation points Microsoft Employee
2023-10-17T12:01:30.5733333+00:00

Is it possible to access lake database tables created through Synapse Notebooks using SQL authentication in SSMS? Currently, we can only access the tables using AD authentication. We tried creating external data source and file formats it works for on-demand SQL , but this approach do not work because the lake database is a replicated database. How can we access the tables through SQL authentication (username and password)? Any help would be appreciated. Thank you.

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.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247 42,451 Reputation points MVP Volunteer Moderator
    2023-10-19T10:12:00.1666667+00:00

    Hi Srikanth Thota:

    Thanks for reaching out to Microsoft Q&A.

    SQL user wont be scoped to storage, hence you have to create a user to access the file from storage. See the answer below where it has been clearly mentioned with syntax...

    https://stackoverflow.com/a/67092270

    try this and let me know if this worked

    Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.