Hey David -
You don't want to connect to SQL Server via ODBC - you should use the native connectors. If I were you, I'd jump out to tableausoftware.com/drivers and download/install the latest/greatest SQL Server drivers from Microsoft.
Are you able to connect to SQL Server at all (using Excel, for example)? It might be helpful if you post the actual connection error message - there are a couple of different flavors..
Thanks for your reply. I am actually trying to connect to the native SQL connection in Tableu. I can connect to the tables in question if I use Microsoft SQL server application outside of Tableau.
I will head over to the drivers later and see if that works.