Failed to connect to MS SQL server from Power BI Desktop

Question

Dear Power BI Technical Team,

Would you please advise how to solve such DB Connection failure?

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

Some hints from Google but they cannot help:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
https://community.powerbi.com/t5/Power-Query/Failed-to-connect-to-SQL-Server/td-p/28939

Answer 1

Also ask Power Bi experts. They're actively answering question in dedicated forums here.

https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

Answer 2

Hi,

Add your IP address to firewall rules Azure SQL

https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure

Also follow with this troubleshoot guide -

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15

Answer 3

Hello PL LAM, This happens when you are adding an incorrect Server name, so in order to solve it, try first checking the server name, and try to correct any mistakes on it. It works for me!