For Tableau Desktop 9.3 and later, the Microsoft SQL Server driver is installed by default.
Are you using mac, if mac then Refer
Yes I am using a Mac, the fully qualified server name does resolve to an IP address and from what I can tell the network path to the location is fully open.
I am able to connect successfully with the same DB, using the same credentials from a Windows pc.
I am also able to connect successfully with another SQL Server DB (UAT one) that is exactly the same except for the fact that the PROD DB is mirrored.
This has got me (and others in the office) stumped....