I'm trying to connect to the Tableau Server tables in our lab server environment from my local machine, but I'm getting an error message. I followed the instructions here and set a password for readonly and then restarted the server. I'm able to sign into the server url in Tableau, so I know I am using the correct Server name.
Mar 21, 2016 6:48 PM
Hello Sarah,
Are you putting the https:// in the server field for the postgres server? If so please remove it. You should only use the DNS host name without a protocol. Also the Tableau Server postgres database is usually running on port 8060 not the default port for Postgres
Robin
Mar 21, 2016 8:20 PM
try running with port 8060 instead.
Thanks Robin! I updated the port and removed https:// from the server field and I'm now connected!
Hi Robin,
I was able to successfully connect to the postgres tables for the lab environment after following your comments. I then followed the same process to enable access on our production server and tried connecting to the production server postgres tables via Tableau, and now I'm getting a new error message:
We are using Tableau 9.2 in both our lab and production environments.
Thanks,
Sarah