0

I have a SQL Server database which I am connecting to via bastion host. Bastion server is a Windows server in AWS. So I need to first RDC to Windows bastion host from there I again need to RDC to the database server.

I have whitelisted my IP to bastion security group. I need to connect Tableau desktop to SQL Server now.

What configuration I need to place to make this happen?

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Deepak nigam
  • 99
  • 1
  • 15
  • Have you opened up the relevant ports in the DB security group? Where is the Tableau instance, in AWS as well? – blinu Apr 22 '22 at 09:27
  • its outside aws. We can attach static ip to the machine and whitelist it in bastion host. – Deepak nigam Apr 22 '22 at 09:34
  • DB server can accept request from bastion only. – Deepak nigam Apr 22 '22 at 09:34
  • Ok cool, a reverse proxy should do the trick. You can set it up on your bastion host and forward your Tableau traffic through to the backend DB server. Check this one for example: https://dev.to/jordonr/reverse-proxy-ms-sql-with-nginx-3e90 – blinu Apr 22 '22 at 11:10

0 Answers0