5 Replies Latest reply on Nov 22, 2016 1:20 PM by Adam Adam

    Microsoft SQL Server was unable to establish an impersonated database connection. Unable to connect to the server

    Adam Adam

      Hi,

       

      If we have a new SQL users want to connect with for Tableau Server (web), does anything have to be done on the Tableau Server side?

      We've added the service account to the SQL server, but are unable to connect from the tableau report published on the web.

      I added !SvcTableau with read access to all the DBs on that server.

       

      we get this error:

      "

      An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator.

       

       

      Microsoft SQL Server was unable to establish an impersonated database connection. Unable to connect to the server "ilnlksitsql\prod2014". Check that the server is running and that you have access privileges to the requested database.

      2016-11-22 18:26:28.499, (WDSN0qwbMDAAACAMvyUAAAPH,4,0)

       

       

      Would you like to reset the view?"

       

       

      Thank you