Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm unable to connect to Azure SQL database with below error message, any1 know what's that means?
@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,
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |