1 of 1 people found this helpful
Verify that the SQL Server database has granted access to the Tableau Server's "Run as" account. Although the user might have access to the database from his/her desktop, once the workbook is published to the server, the server account will need to have access.
One other issue that cropped up for us with one user was that at one point they tried embedding a password with their workbook. So, even after granting access to the Tableau Server account the database was still prompting him to Log in. I had to go to the Maintenance page on the server and "Clear saved passwords for all users" which fixed that problem. ** Be careful with that one as I am not entirely sure of your configuration.
Hope this helps.
Thanks, Tim. Our IT guys are on it. I will report back.