Need a bit more info to answer this problem. Lots of questions for you to narrow down this issue:
- Is this a new issue that was working before?
- What has changed recently?
- Does it fail when manually triggered?
- Does it fail repeatedly or just a single time?
An easy troubleshooting steps is to try republishing the datasource and refreshing.
Thanks and hope this helps!
This is the first time issue while refreshing the extract from tableau server.
There is no change in tableau server
Yes,it's failed even manually triggered.
Repeatedly we got this issue
Yes, SQL Server drivers are installed in server machine
That's good info - we don't know that it's ever worked so we can't make any assumptions. To narrow down the issue further, I would suggest installing Tableau Desktop on the computer running Tableau Server and then open Tableau Desktop as the Run As User (hold down shift then right-click and select "run as another user") and attempt to connect and refresh from the data server. If that is successful, there is likely something within Tableau Server causing the problem and should be investigated by Tableau Technical Support (probably need to dig into the logs). If the refresh and connection fails, there is likely something preventing the Tableau Server from accessing the datasource like user permissions, firewall or a proxy.
Hope this helps!