We have an instance of Tableau server. Our Tableau desktop application can connect to Sql Server but when we log into the local instance it will not connect and shows the following issue:
Can’t connect to Microsoft SQL Server
Detailed Error Message
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'tableau-hex'.
Integrated authentication failed.
Is the answer to create an active directory user 'tableau-hex'???
Thanks
Hi @B Page,
It sounds like you are using the Run As Service account set to 'tableau-hex' which isn't set up on the SQL database. Depending on your database permissions you will either need to set up an active directory user, or just a user with access for the SQL database. There's more detail on this here.
