Forum Discussion
Solved
Unable to connect SQL Server
I am trying to connect a SQL server using power bi but getting the following error. Surprisingly I am able to access it using Excel or SQL Server Management Studio installed in my PC. I have also ena...
Hi avinrosh,
In your scenario, does the SSMS installed on the same machine as Power BI desktop runs?
If not, the problem may could be for either Named Pipes connections or TCP/IP connections. You can refer to this blog to solve your problem.
https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/Regards,
Daniel He
Hi avinrosh,
In your scenario, does the SSMS installed on the same machine as Power BI desktop runs?
If not, the problem may could be for either Named Pipes connections or TCP/IP connections. You can refer to this blog to solve your problem.
https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/
Regards,
Daniel He