Unable to Import New Users in Active Directory to Tableau Server
Published: 19 Aug 2016 Last Modified Date: 07 Feb 2023
Issue
When attempting to sync to Active Directory, less than the total number of users in a group are being imported.
Additionally, you are not able to find new users when attempting to add them individually.
Environment
Tableau Server
Resolution
The Tableau Server Administrator and your Active Directory team should investigate to determine if there is an issue with these users on the domain controller with a possible LDP.exe query. When using the LDP tool, remember to select and query the following:
Run ldp.exe as the Tableau Server run as user, on the Tableau Server machine.
Set the port to 636 and ensure SSL is checked. For 'Domain', enter the domain controller to query.
Select an anonymous bind by selecting 'Bind' without entering any user information.
Select '-No Children' when setting up the search filter.
In the search box:
Set 'Base DN:' to the domain DC (The Base DN should look like this - Domain: name.lan, Base DN:dc=name,dc=lan)
Set 'Scope' to 'Subtree'
In 'Filter' enter the following query to search for a specific user or to use a wild card search: