I want to set-up a tableau desktop pro to connect to a SQL server DB which is on a different machine on the same VPN. I would like to know if this possible. If there is a document/link with steps it would be even better.
As long as that machine and database are visible over the network, I don't see why not. I often connect to remote databases using Tableau over VPN. Are you able to connect to that SQL server using SSMS (or similar?)
Or is there another complication that I'm missing?