Forum Discussion

ptimmerm's avatar
ptimmerm
Frequent Visitor
1 year ago
Solved

Cannot connect to SQL DB w/PBI Desktop - Can with SSMS and ADS

Hi all. I must be making a simple mistake, but here's my situation.   I spun up a new Azure SQL DB. It allows for Entra Authentication and SQL Server Authentication. Firewall rule has been setup to...
Need Help
Tips and Tricks
  • ptimmerm's avatar
    ptimmerm
    1 year ago

    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.

ptimmerm's avatar
ptimmerm
Frequent Visitor
1 year ago

Thanks for the reply. Unfortunately that option appears to just be binary, "encrypt or not". It is not the same level of configuration available in, for example, the ODBC driver setup I referenced.

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
1 year ago

ptimmerm 

have you tried unchecking the Encrypted? if yes, then were you able to connect to you sql server?

  • ptimmerm's avatar
    ptimmerm
    Frequent Visitor
    1 year ago

    I did try that and still no luck connecting.

    • tharunkumarRTK's avatar
      tharunkumarRTK
      Icon for Super User rankSuper User
      1 year ago

      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!
      • ptimmerm's avatar
        ptimmerm
        Frequent Visitor
        1 year ago

        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.