Tableau Publish to Server Error signing in to Tableau Server

This is a strange situation but definitely a big problem for me.

My personal credentials work just fine with the Tableau Publish to Server tool.

I need to use the service account credentials which we use with tabcmd to publish Tableau datasources. This is the same service account running the Tableau Server. It is a Tableau Server Admin with full permissions.

I can use the service account credentials to set up the tool connection, then see the list of projects and datasources and such in step 2 of the tool's configuration.

But when I run the configured tool, this happens: ☹️

Publish to Tableau Server (123) Tool #33: Tool #4: Tableau Server API Request (Sign-in) Error Code 401001: Signin Error -- Error signing in to Tableau Server

I have a hunch the problem is special characters in the service account name (.) or the password (+=@). What do you think?

Bug

Tableau

Accepted answers

hroderick-thr

I should have searched better because this has been solved here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Publish-to-Tableau-Server-Error-Messages/td-p/628451

Adding a bit to it, these characters seem to cause trouble:

These need special handling for command line apps

https://community.tableau.com/s/question/0D54T00000C6ntnSAB/special-characters-in-usernamepassword-issues-with-integrated-authentication-on-server

These cause problems in urls

https://kb.tableau.com/articles/issue/special-characters-in-url-parameters

So avoid these

! * ' ( ) ; : @ & = + $ , / ? # [ ] | < > \ ^ ” * %

I've found $ is OK if you must have one. There are ways of dealing with special characters in userids and passwords, but it would take a fix to the tool at the code level to add escape syntax to them

All comments

hroderick-thr

I should have searched better because this has been solved here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Publish-to-Tableau-Server-Error-Messages/td-p/628451

Adding a bit to it, these characters seem to cause trouble:

These need special handling for command line apps

https://community.tableau.com/s/question/0D54T00000C6ntnSAB/special-characters-in-usernamepassword-issues-with-integrated-authentication-on-server

These cause problems in urls

https://kb.tableau.com/articles/issue/special-characters-in-url-parameters

So avoid these

! * ' ( ) ; : @ & = + $ , / ? # [ ] | < > \ ^ ” * %

I've found $ is OK if you must have one. There are ways of dealing with special characters in userids and passwords, but it would take a fix to the tool at the code level to add escape syntax to them

mkosmicki1

I use TabCmd to do some of my server processing and always forget that may Tableau Password cannot have those specific special characters. thanks for posting this here because there are probably more than one of us that need the reminder and the solution. 🙂

Best,

Michelle

bdewitt760

I removed the special characters and it worked. Thanks so much for posting this as i was having the same problem.

srdevireddy

I don't have special characters in the password. But still it's throwing an error. Any possible resolution?

"Failed to signin to Tableau."

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703