Forum Discussion
Solved
Can't connect to SQL server
Hi, I'm trying to connect to an external SQL server using Power BI desktop but I'm getting an error: Details: "Microsoft SQL: A network-related or instance-specific error occurred while establish...
beckett,
Are you able to connect to SQL Server from SQL Server Management Studio(SSMS)? Ensure that SSMS is installed on the same machine with Power BI Desktop.
Besides, please follow the instructions in the article below to troubleshoot this connection error.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine
Regards,
Lydia
Turned out it was to do with whitelisting the IP, but I was going up a blind alley thinking the request originated from a Power BI server somewhere - actually my own IP wasn't whitelisted! Thanks for the advice everyone.