Forum Discussion
Cannot connect to SQL DB w/PBI Desktop - Can with SSMS and ADS
Just wanted to say thank you to everyone for their assistance. We have resolved the issue. Turns out it was a firewall thing, but not a straight blocking of 1433 outbound. There were some AppIDs that were inconsistent/misconfigured.
Super Userhave you tried unchecking the Encrypted? if yes, then were you able to connect to you sql server?
I did try that and still no luck connecting.
- tharunkumarRTK
Ok, May I know where this SQL server is hosted?
what is the port number that you are using to connect to it from sql server or ADS?if it is not 1433 then can you try appending the port number to the hostname?
like <Hostname::1433>Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
It is in Azure North Central US. It is listening on 1433.
There has to be something internal to my work network blocking it, but I have no idea what that would be since I can hit it via SSMS and ADS. Might be a GPO thing. Does not seem lie a firewall thing anymore.
I can hit it just fine from Power BI Desktop installed on my personal laptop.- tharunkumarRTK
Hmm. May you can use tools like wireshark and see the network trace?
create one trace while you are connecting from SSMS and one another trace when you are trying to connect from power bi desktop and see if that gives any information.
Also, If you are using your organiztion network then you can ask your network team to unblock port 1433 for your ID. As far as I know some organizations might have user/region/system specific network rules
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!