Connect to Azure SQL

[Anonymous]

I'm unable to connect to Azure SQL database with below error message, any1 know what's that means? 

[v-sihou-msft]

@Anonymous

Make sure your input correct server name. You can also try to connect SQL Azure via SSMS. If it also fails, please check the Azure firewall configuration as @Greg_Deckler suggested.

Regards,

[Diegres]

I have a similar / identical issue:

Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)"

Details: "An error happened while reading data from the provider: 'System.IO.FileLoadException"

I am able to connect to my Azure SQL Database from SSMS, so the firewall ports are configured as expected. Exhausted my options - Please help.

[Greg_Deckler]

I would guess firewall rule for Azure SQL DB needs configured:

https://community.powerbi.com/t5/Desktop/Can-t-connect-to-Azure-Database/td-p/7761