Share via

getting error while using SQL Auth for login ssms

Gaurav Patil 0 Reputation points
2024-08-07T12:56:39.8266667+00:00

I have successfully connect with sql Auth but when i use external table i got an error

"External table 'gold.Budget_Master' is not accessible because location does not exist or it is used by another process."

but when i login with MFA it works properly.

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.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 34,571 Reputation points Microsoft Employee Moderator
    2024-08-13T06:33:31.5133333+00:00

    Hi Gaurav Patil ,

    I understand that you are facing error while trying to access or create an external table in synapse Serverless SQL pool.

    Before trying to access the external table, there are few pre-requisites that needs to be taken care of, the following objects needs to be created :

    • DATABASE SCOPED CREDENTIAL
    • EXTERNAL DATA SOURCE
    • EXTERNAL FILE FORMAT

    Kindly checkout the documentation: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables?source=recommendations#prerequisites

    Reference videos:

    1. Create External Data source and DATABASE SCOPED CREDENTIAL in Azure Synapse Analytics
    2. Create External File Format in Azure Synapse Analytics

    Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

    Was this answer helpful?

    0 comments

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.