Forum Discussion
WW
10 years agoFrequent Visitor
Unable to connect Power BI to SQL
Hello all, I am facing this error for a few days and it's driving me crazy. I just downloaded Power BI Desktop and hope to connect it to my SCCM database. I have disabled my firewall, check my I...
Anonymous
10 years agoNot applicable
Hi WW,
Could you please firstly use SQL Server Management Studio to connect to the remote SQL Server instance and check if it is successful? If it also fails, please follow the steps in this blog to troubleshoot this issue.
In addition, we need to verify that if you use a Windows login or SQL login to connect to SQL Server, and how you specify the settings in the following screenshot.
Thanks,
Lydia Zhang
WW
10 years agoFrequent Visitor
Hi Lydia,
I am able to successfully connect to the remote SQL Server instance from another server. I have used both Windows and Database login, but error appears on both.