Forum Discussion
Gateways for Azure SQL Database VM deployed from Power BI Desktop
desertislesql Grr. I was just going to post an edit to validate that... IAAS is considered "on-premises" So you would need a gateway. Sorry if I mis-understood the initial question. There is a slight wording difference in names. (PAAS = Azure SQL DB), (IAAS = SQL DB on Azure)
IAAS = Need a Gateway
PAAS = Do not need a Gateway
desertislesql Grr. I was just going to post an edit to validate that... IAAS is considered "on-premises" So you would need a gateway. Sorry if I mis-understood the initial question. There is a slight wording difference in names. (PAAS = Azure SQL DB), (IAAS = SQL DB on Azure)
IAAS = Need a Gateway
PAAS = Do not need a Gateway
We just migrated to a VM in Azure running SQL 2014, which I believe is IAAS and therefore we need a gateway. Do you know of any documentation on what type of gateway and where it should be installed?
gjohnston You probably want to install the on-premises data gateway - documentation here. While it should work on any machine in your domain, you would want to install it on the machine that you will be accessing data the most from. In that respect, you won't be making extra calls between machines for certain connection types.