Forum Discussion

PremK's avatar
PremK
Resolver I
1 year ago

Gateway - MS SQL Server ( On-Premises )

Im using MS SQL Server as Data Base, which is on-premises server. I had build a report in Power BI using this Data base.   To refresh this data set in PBI Service,  Is it possible to connect this d...
Need Help
AnkitKukreja's avatar
AnkitKukreja
Super User
1 year ago

Hi! PremK 

 

The best practice is to have your GW on a virtual machine so it keeps on running, having it on your machine means, it stops working once you log off and this will lead to failure in data refreshes.

 

 

  • PremK's avatar
    PremK
    Resolver I
    1 year ago

    you mean to say i need to install GW in the VM were the MS SQL Server is insatlled, right ?

     

    • sergej_og's avatar
      sergej_og
      Super User
      1 year ago

      No, pls don't do it this way!
      Use one stand-alone VM, only for your GW client.
      This VM (with your GW) should then has FW-rule to be able to connect to your SQL Server.

      Pls don't use GW on the same VM where SQL Server is stored.

      Regards 

      • PremK's avatar
        PremK
        Resolver I
        1 year ago

        Can you pls give some more details about this. 

        what is FW-rule and what do you mention as standalone Virtual Machine, and even if i setup this separate VM, how it could connect with SQL Server and PBI. 

         

        Can you explain these pls.

    • AnkitKukreja's avatar
      AnkitKukreja
      Super User
      1 year ago

      PremK 

      Yes that's the best approach.