Failed to connect to MS SQL server from Power BI Desktop

PL LAM 21 Reputation points

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:

Azure SQL Database
{count} votes

Accepted answer
  1. Anonymous

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

    --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

    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