Connect to Azure SQL

Anonymous · ‎03-08-2017

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

v-sihou-msft · ‎03-15-2017

@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 · ‎06-11-2017

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 · ‎03-08-2017

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...