connection error when trying to connect to sql database via azure data studio

Question

I created an azure sql database and added my IP address to the firewall rules. In "Getting started" I use the button "Open Azure Data Studio" to connecto the database via Azure Data Studio. In Connection Details the Authentication type "SQL Login" is preselected. I type in my Azure Account credentials, user name and password, and click "Connect". Then I get the error:

Connection error

Cannot open server "XXXXXXX" requested by the login. The login failed.

What am I missing?

Answer 1

Hi blubb •,

Welcome to Microsoft Q&A forum.

As I understand, you could not connect to Azure SQL Database using Azure Data Studio.

You have mentioned that IP address is added, and authentication type selected is SQL Login.

Please check if the SQL Server name is given correctly:

Try to update Azure Data Studio to the latest version if not already done.

Let us know if you are unable to connect with screenshots and server configuration details so that we can check at our end.

Awaiting your reply.

Thanks

Answer 2

Hi blubb •

Thanks for replying.

Could you please ensure that server name is correctly present if Input Type is selected as Parameters with "servername.database.windows.net".

Also, please try once using Connection String option of Input Type if that works.

Thanks

Answer 3

"SQL Login" is preselected. I type in my Azure Account credentials

Your "Azure Account credentials" aren't the SQL Login credentials, that's why login fails.

Use the SQL account defined during database creating and create a SQL login.

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver16

Answer 4

It works using Authentication mode "Microsoft Entra MFA" in SSMS or "Microsoft Entra ID - Universal with MFA support" in Azure Data Studio. As Olaf Helper mentioned above, you need to create a new SQL Login to be able to connect to the database using "SQL Login" as authentication mode. But I haven't been successful yet in doing so.

Answer 5

Hi blubb •

This is strange.

Could you please post the details over the link here: https://github.com/microsoft/azuredatastudio/issues

Or else please raise support case for more analysis and assistance.

Thanks