Issue
When opening views with live data source connections, you may see the following error:
"Session Ended by Server
An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator.
Session ID: <string>
[Microsoft][SQL Server Native Client 11.0][SQLServer]Login failed for user <username>.
Integrated authentication failed.
create.xml
class DataSourceException
Unable to connect to the server <server name>. Check that the server is running and that you have access privileges to the requested database.
<Timestamp>
Would you like to reset the view?"
An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator.
Session ID: <string>
[Microsoft][SQL Server Native Client 11.0][SQLServer]Login failed for user <username>.
Integrated authentication failed.
create.xml
class DataSourceException
Unable to connect to the server <server name>. Check that the server is running and that you have access privileges to the requested database.
<Timestamp>
Would you like to reset the view?"
Or when working with extracts on Tableau Server, you may notice that workbooks that are connected to Microsoft SQL Server data sources do not refresh or you see the following error message in the Background Tasks admin view:
SQL Server database error 0x80040E4D: Login failed for user <username>
Note: <username> in the error is different from the user who published workbook.