Forum Discussion

MrMP's avatar
MrMP
Helper III
5 years ago
Solved

Can not connect to SQL from VM

Hi All,

 

I have Power BI desktop installed on virtual machine with Static IP. That IP is whitelisted at clients SQL server (sqlexpress). Auth is basic and I have user and password. No matter what I try I cant connect to the db and view they created. What am I missing? Do I need to whitelist any other IP. The idea is to have gateway on VM and have it refresh the report from their SQL server.

Thank you for any help, I am new to this!

SQL

7 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    5 years ago

    Try run Power BI Desktop as "Run As Administrator" and see if it still persists.

    • MrMP's avatar
      MrMP
      Helper III
      5 years ago

      Thank you for the answer but that did not help. Any other suggestions? Do they have to whitelist any other IP?