TableauServerUserFull Initial SQL Variable Result is Different Between Tableau Desktop and Tableau Server

Issue

When using initial SQL and the parameter, TableauServerUserFull, Tableau Server returns the NETBIOS/ nickname when passing the variable while on Tableau Desktop, the result shows the Domain Name.

Desktop:
SET tableau_user = [TableauServerUser]; ---------> SET tableau_user = 'joeblogs'
SET tableau_user = [TableauServerUserFull]; ---------> SET tableau_user = 'contorso.domain.com\\joeblogs'

Tableau Server:
SET tableau_user = [TableauServerUser]; ---------> SET tableau_user = 'joeblogs'
SET tableau_user = [TableauServerUserFull]; ---------> SET tableau_user = 'Netbios\\joeblogs'

Environment

Tableau Server 2022.1 and newer
Windows Server 2019

Resolution

Run the following commands on Tableau Server:

tsm configuration set -k DelegationUseFullDomainName -v true --force-keys

tsm pending-changes apply

Cause

Tableau Server returns the Netbios/nickname when using the variable "TableauServerUserFull" while Tableau Desktop returns the Domain by product design.