User Name and Password for Dedicate SQL Pool

Question

User Name and Password for Dedicate SQL Pool

Haoran Bai 80

I created a dedicated sql pool in my synapse work space and try to connect to it using DBeaver, but I don't know my user name and password, I didn't remember I set them when I created the dedicated sql pool.

Accepted answer

1 additional answer

Your answer

Answer 1

Hi,

If you forgot your admin user name and password you can reset the password. To do this, navigate to your Synapse workspace in Azure portal. On Overview blade you will see your SQL admin username, similar to below:

User's image

Make a note of username. To reset password, click Reset SQL admin password button at the top:

User's image

Enter new password twice and click Save.

NOTE: If Reset SQL admin password button is disabled, it most likely means that only Microsoft Entra ID authentication is supported. To change this, navigate to Settings -- Microsoft Entra ID blade, uncheck Support only Microsoft Entra ID authentication for this workspace and click Save.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Answer 2

Hello , Welcome to MS Q&A

Reset the Password: If you have forgotten the password, you can reset it in the Azure portal:
- Navigate to your Azure Synapse Analytics workspace.
- Go to the dedicated SQL pool you created.
- Look for the option to reset the server admin password.
Create a New SQL Server Authenticated User: If you want to create a new user for connecting:
- Connect to the master database on your server with your server admin login.
- Create a new server login and user with the following SQL commands:
```
        CREATE LOGIN NewLogin WITH PASSWORD = 'YourNewPassword';
        CREATE USER NewUser FOR LOGIN NewLogin;
        
   
   
```
Use Microsoft Entra ID: Alternatively, you can use Microsoft Entra ID for authentication if it's enabled.

For more detailed guidance, you can refer to the Azure Synapse documentation on managing security and authentication.

If you need further assistance, let me know!

Kindly accept if it helps

Thanks

Deepanshu

Share via

User Name and Password for Dedicate SQL Pool

1 additional answer

Your answer