I cannot access Azure SQL database using query editor. However I can access it using SSMS with the same SQL Server authentication login and password

user_13543897 0
Viewed 449
azure-sql-database
1 Answers

Please make sure you set "Allow access to Azure services" to ON on the firewall configuration of your Azure SQL Database.

enter image description here

Please take in consideration, that Azure AD admin sign in doesn't work with accounts that have 2-factor authentication enabled. In addition, Query editor doesn't support connecting to the master database.

user_81841390
Related