I noticed, when I published the workbook, my MS SQL datasources aren't on the server. I manually add them using the client, and then they are there. I know it's not a driver issue, because I can Test Datasource on server and it connects fine. I also validated that my tabelau_service account does have the same rights to the sql db that I have. Also, I didn't cut out the sql server name/ip in the above error, yet there is none, just ".
If you build the workbook from scratch and reestablish the connection to the data source, then publish the workbook, do you experience the same issue? Do you know if any other workbooks are connected to that database and also published to Tableau Server, but work as expected?