Hello,
I am trying to automate my Prep flows through Command Line Scheduling and created the batch file with the instructions provided by Tableau.
My Prep flow connects to a Microsoft SQL Server so I have created the json file with the credentials.
However it looks like it can't connect to the server.
C:\WINDOWS\system32>"C:\Program Files\Tableau\Tableau Prep Builder 2019.4\scripts"\tableau-prep-cli.bat -c "C:\Users\jylee.KMAU\Desktop\Prep flow automation test\FLOW\Test.json" -t "C:\Users\jylee.KMAU\Desktop\Prep flow automation test\TEST FLOW.tfl"
JAVA_HOME is set to : C:\Program Files\Tableau\Tableau Prep Builder 2019.4\scripts\..\Plugins\jre temporarily
Preparing to run the flow : C:\Users\jylee.KMAU\Desktop\Prep flow automation test\TEST FLOW.tfl
Loading the flow.
Creating temp directory at C:\Users\JYLEE~1.KMA\AppData\Local\Temp\prep-cli-3216322997740128845
Loaded the flow.
Updated the connections with supplied credentials.
Failed to connect to server 10.126.XXX.XX with connection ID b5fbb3bc-5002-440c-a983-93c0f1aca502:
An error occurred while communicating with Microsoft SQL Server.
Check that the connection is valid then try again.
Details:
[Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
[Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Unable to connect to the Microsoft SQL Server server "10.126.XXX.XX". Check that the server is running and that you have access privileges to the requested database.
I am able to connect to the server in Prep itself though..
Any help is appreciated.
Thanks,
Hi Jason,
Maybe you already checked this, but if you haven't I would recommend checking the .json file used to make sure the SQL server hostname/IP is and the credential used is correct, also if you are specifying anything else, port name, etc. make sure everything is correct.
If that doesn't resolve the issue, I would recommend contacting Tableau technical support with the json file and the log files for further investigation.
Regards,
Ichiro
