Forum Discussion

michaelshparber's avatar
michaelshparber
Icon for Advocate V rankAdvocate V
6 years ago
Solved

What do I need to Connect to SQL Server hosted on AWS?

I want to publish to the service a desktop model that connects to a SQL Server hosted on AWS. What will I need to schedule a refresh? A Gateway on AWS? Some settings on AWS? Will appreciate any he...
Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago
    Hi there

    The EC2 is a virtual machine?

    You create a VM running Windows in AWS and then install and configure the Gateway on this VM?
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

What you would need to do, is to install the Gateway on an EC2 instance in AWS that can connect to the SQL Server.

Then you can use the Gateway to schedule refreshes or DirectQuery
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    GilbertQ 

    Any reference on how to install the Gateway on EC2?

    I've looked in the documentation - and no mention of AWS...

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      6 years ago
      Hi there

      The EC2 is a virtual machine?

      You create a VM running Windows in AWS and then install and configure the Gateway on this VM?