Cannot access new Azure SQL DB

Question

I just created my first Azure SQL DB. I went into Query Editor so that I can start creating tables. I get this error.

Active Directory authentication

Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from inside your virtual network (https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database).

I assume that I picked the wrong authentication method when setting it up. But I cannot figure out where to go to change it to the right one. There is NO Active Directory option under "Settings." Where do I go and what should I set it to?

Answer 1

You are not using wrong authentication method you have "Deny public network access" knob to Yes in the Firewall settings on my Azure SQL Database server.

Just Change it to No or check the exceptions and add your IPs