question

PLLAM-9378 avatar image
0 Votes"
PLLAM-9378 asked ·

Failed to connect to MS SQL server from Power BI Desktop

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://docs.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
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@pllam-9378

From the documents it looks like this is for On prem version of SQL Server. This forum is for the Azure SQL DB.

For more traction please go to SQL Server forum:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

If that is not the case, please check the answers below or elaborate on your architecture.

Thanks
Navtej S

0 Votes 0 · ·
DSPatrick avatar image
0 Votes"
DSPatrick answered ·

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.







· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MalleswarReddy avatar image
0 Votes"
MalleswarReddy answered ·
· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.