I can't get my local machine to connect to the azure database

Question

Hello,

I don't have a SQL Server Manamanagement studio on my local machine. However, I am creating a user form application that using a database. I am new to azure and I'm learning it. I wanted to do what I felt was a basic thing: connect my application to the database I created in azure.

I have spent all day yesterday and today doing various tutorials including configuring my windows defender, retrying other setting up other databases and so on. I'm now at the point where I've learned a few things. I'm at my wits and I need to get this connected today! I got to verify certain queries will work.

I've created a udl file to test the connection and nothing. It can't find the server, which is step one. I've done in reverse as well where I copied and pasted the connection string into the udl file itself and it made no difference.

Somebody help!

Ben

Answer 1

Hi Ben,

In the Azure portal, please navigate to your Azure SQL Server. Next click on Security -- Networking blade. Under Public access tab, please make sure it is set to Selected networks and under Firewall rules you have your local PC's public address added.

If needed you can check your local PC's public IP by browsing to https://api.ipify.org

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

Thanks.

-TP