Azure SQL Database
An Azure relational database service.
How to connect Azure SQL Database from Local machine(Azure Data Studio) in MAC?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 48%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Binod Gurung
0
Reputation points
I am using MacOS 13.2.1. I created Azure SQL Database in the portal. I added my client's IP to the firewall. I expect it to connect that SQL database to my local machine but it is not. I can browse that database in the connection box though. Are there any other configurations I am missing? I was thinking if it could be some firewall issues in MAC but there are no particular firewall configurations.
Azure SQL Database
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SSingh-MSFT 16,461 Reputation points Moderator2023-04-13T06:03:24.84+00:00 Hi Binod Gurung,
Welcome to Microsoft Q&A forum and thanks for using Azure services.
As I understand, you are not able to contents of the database in Azure Data Studio in Mac.
Could you please refer to the steps mentioned here and see if you are able to connect and view database content:
Install Azure Data Studio on a Mac
Awaiting your inputs, thanks
-
Binod Gurung 0 Reputation points
2023-04-15T01:55:27.9266667+00:00 @SSingh-MSFT Thank you for your response. My problem is not regarding the installation of Azure Data Studio. I have installed Azure Data Studio on my system. I created Azure SQL database in Azure portal. Now I need to connect to that database server using Azure Data Studio. This is where I have a problem. I get the error message I added before. Best regards,
-
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator2023-04-15T17:22:51.7866667+00:00 @Binod Gurung Do you mean you are able to see the list of databases under the connection and when you connect you are getting the connection error?
I tried to connect and I was able to connect successfully on Mac.
it could be an intermittent connection issue can you try again?
Regards Geetha
-
SSingh-MSFT 16,461 Reputation points Moderator
2023-04-18T11:58:25.99+00:00 Hi Binod Gurung, Just checking in to see if the above suggestion by Geetha helped. Please let us know so that we can further investigate. Thanks
-
Binod Gurung 0 Reputation points
2023-04-21T03:18:20.7833333+00:00 @GeethaThatipatri-MSFT Yes, I can see the database in the list but get an error while trying to connect. Still the same issue. Do I need to open the port on my machine or any other configuration to do?
-
GeethaThatipatri-MSFT 29,587 Reputation points Microsoft Employee Moderator
2023-04-23T23:25:22.76+00:00 @Binod Gurung Can you try checking to see if you are able to connect to localhost if you have one? or I would suggest reinstalling ADS. Regards Geetha
-
SSingh-MSFT 16,461 Reputation points Moderator
2023-04-25T06:15:40.8066667+00:00 Hi Binod Gurung,
Just checking in to see if the above suggestion by Geetha helped. Please let us know so that we can further investigate. Thanks
Sign in to comment
Sign in to answer