"Embedded Passwords" is a global server setting that needs to be turned on by a Tableau Server admin - settings are in the Maintenance page of the Admin menu. The next time you log in from Tableau Desktop, you'll then see that option.
FYI, here's how we resolved the situation. 1) We created a windows account for the tableau service, and have tableau run under that account. 2) we added the tableau service as a server login to all the various db servers. 3) we added the tableau service as a user to all the relevant db's, in the role of db_datareader. 4) I ensured that the tableau workbooks use windows integrated security. 5) I republished all the workbooks to the server.
That appears to have resolved all the issues.
A note to the tableau technical writers -- you could outline something like this (adding in the step where on the tableau server you make the appropriate selections on Administration>>Maintenance>>Settings) in the help docs and maybe on a faq on this site. Apologies of course if this is already somewhere in the documentation, but I didn't find it. I also understand that this is specific to sql server...
Great product and support, though! thanks!
I checked "Embedded Credentials" on the server, logged out and back in through desktop and am not seeing an option to save the credentials.
How'd this work for you? When I tried this, I was unable to connect to the server - from anywhere. Had to go back to network service.
tbahlke - are you using SQL Server and Windows authentication, or are you using a database password? Tableau Server "Embedded Credentials" refers to the latter, while the "Run As User" is relevant to the former.
Im impressed. Youre truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Im saving this for future use.