Typically this issue can be resolved by following the steps in the below Knowledge Base article:
I am using Microsoft sql server 2012 as database.it is in one server and my tableau server is in another server.i created a data source in my local machine and upload that data source into my tableau server. after upload that datasource i am trying to create a report in tableau server itself that time i am getting the above error. Please help to overcome that issue.
I am not that much familiar with tableau server.
The most common reason for this issue on Tableau Server is that the drivers are not properly installed on the Tableau Server machine. In order for Tableau Server to communicate with the database and create the view, it must have the correct drivers installed on it. The correct drivers for SQL Server 2012 can be found on the Tableau Drivers page here:
If you do not have access or permissions to install the drivers on the Tableau Server machine, you may need to work with the Tableau Server administrator to have the drivers installed on the machine.
Hope that clears things up!