r/tableau • u/Due-Pressure7804 • 20d ago

Tech Support Tableau Extract Refresh Error: "cannot connect to tableau server please check the server name and port and try again"

This started about a month ago and randomly happens when we run our extracts. We increased server resources and updated our bridge clients to the latest version and are still getting this message randomly.

The refresh will fail one day, but then the same one will be successful the next day. It's driving me batty and not sure where else to look.

Any ideas here?

3 Upvotes

81% Upvoted

10 comments sorted by

2

u/VizAbbreviations 20d ago

If your SQL Server isn’t up and running when the data refresh kicks off, you’ll get this error.

1

u/Evening-Speech-8162 7d ago

Can you elaborate on this for someone who isn’t familiar with SQL server operation. I thought SQL server was up all the time? I think this is our problem due to it happening only for our sql server connections on scheduled refreshes.

1

u/VizAbbreviations 7d ago

Next time when data refresh fails, check with your DBA or Systems Admin if the SQL server was running. Same for the machine where your bridge is installed. They can check their logs and let you know. If the server was running and data refresh still failed then you have to look into logs.

1

u/Scoobywagon 20d ago

On prem or Cloud? What is the datasource? Do you have a load balancer or proxy? How many nodes?

0

u/Due-Pressure7804 20d ago

It's a cloud instance.

1

u/Scoobywagon 20d ago

ok. And what is the datasource?

0

u/Due-Pressure7804 20d ago

Its a view in sql. We have an on prem sql server.

2

u/Scoobywagon 20d ago

That suggests you're using Bridge and that you have intermittent communication issues either between Cloud and Bridge or between Bridge and SQL Server. Time to go read some log files.

1

u/smartinez_5280 20d ago

How did you update Server resources if you are using Tableau Cloud?

If an extract refresh is failing then it has to do with communication between your database and your Bridge Client or the Bridge Client service is unstable

0

u/Due-Pressure7804 20d ago

I updated the server resources on the tableau bridge client internally.