In order for the workbook to connect to the data source:
Embedded Credentials is allowed on the Tableau Server
Make sure the proper version of drivers are installed on your Tableau Server for SQL Server.
Make sure credentials are embedded during the publishing process
Yes, they can create an extract and publish it to the Tableau Server, thus being a static extract (a snapshot) that will not connect to the SQL Server.
Thank you so much for the assistance and advice.
I'm hoping this will work based on your recommendation and advice, especially embedding the password.