I have a tableau server with several workbooks that are successfully connecting to MS SQL. We use extracts that are occasionally refreshed via a live connection. The workbooks have embedded credentials that allow them to connect to the SQL server.
However, I recently published a workbook on a different site within our tableau server, and said workbook cannot connect to SQL (even though other workbooks are connecting to it on the other site). I'd appreciate any input/advise from others who have encountered this issue.