Share via

How to reset the password of Azure Synapse Dedicated SQL Pool ?

Rachit Pandya 0 Reputation points
2024-05-23T11:24:36.16+00:00

Hello,
When I'm creating a linked service to fetch the data from Dedicated SQL Pool within the Azure Synapse Analytics workspace, it ask for the SQL authentication. Since I hadn't created the username and password at that time, I want to create or reset it now.
Could anyone suggest me the ways to tackle this scenario?

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,553 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. BhargavaGunnam-MSFT 28,111 Reputation points Microsoft Employee
    2024-05-23T15:25:08.0433333+00:00

    Hello Rachit Pandya

    Welcome to the Microsoft Q&A forum.

    The default user name(SQL account) when creating the dedicated SQL pool is- sqladminuser

    To reset the password for the Dedicated SQL Pool in your Azure Synapse Analytics workspace, you can follow these steps:

    1. Open the Azure Synapse Analytics workspace in the Azure portal.
    2. In the "Overview" tab, click on the "Reset SQL admin password" .
    3. Enter a new password for the Dedicated SQL Pool
    4. Click on the "Save" button
    5. Once the password hasbeen saved, you can use it to create a linked service to fetch data from the Dedicated SQL Pool.

    User's image

    User's image

    If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.