Chrissy - did your Tableau Server admin get this working?
Some questions -
- what is the data source?
- what sort of error is occurring
- what version of Tableau Server?
Has the data source been saved to Tableau Server as a Published Data source or is it just an extract that is part of a published workbook?
See - Publish a Data Source
Often having access to the data source from the server can be an issue if permissions are not setup right.