Let's start with basics: have you installed the driver?
You can get it here:
Also, are you able to connect (or use) this server via any other tools?
Yes I have installed the necessary driver. I have not tried to connect to any other tools, but I have been able to successfully enable the web connection to the server, don't know if that helps/means anything.
The following steps may help resolve this.
We were able to successfully connect to Hive after we adjusted the following information in the connection pane in Tableau Desktop:
+ We changed the connection from HiveServer to HiveServer2
+ We changed the port to 10000 (for Hive, the default port, 21050 is for Impala)
+ Changed Authentication type to username and entered a valid username
Did the steps above work for you?