Failed to connect to MS SQL server from Power BI Desktop

PL LAM 21 Reputation points
2020-06-09T04:55:21.803+00:00

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 help9481-ms-sql-connection-failed.jpg:
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

Azure SQL Database
{count} votes

Accepted answer
  1. Anonymous
    2020-06-10T02:44:02.087+00:00

    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.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Winter De Los Santos Morillo 0 Reputation points
    2023-02-09T19:26:54.71+00:00

    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!

    0 comments No comments