EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB439206: In MicroStrategy Intelligence Server 10.x, warehouse pass-through login with Kerberos fails when "Synchronize user/group information with LDAP during Windows authentication" option is enabled


David Currin

Quality Engineer, Senior • MicroStrategy


This article discusses a known issue in MicroStrategy 10.x versions where warehouse passthrough does not work as expected when a certain LDAP related server configuration option is enabled

SYMPTOM
When attempting to run a report or document whose data source makes use of warehouse pass-through authentication using Kerberos, the report or document execution might fail with an error relating to failure to connect to the database, or failure to execute SQL, or might execute successfully but display data for the wrong warehouse user.  The exact behavior will depend on several factors such as what account the Intelligence Server is running under, and whether that account has access to execute queries on the database.
CAUSE
Due to a known defect in Strategy 10.x, if the advanced LDAP option "Synchronize user/group information with LDAP during Windows authentication" option is enabled, the end user's Kerberos credentials are not passed to the database when using warehouse pass-through.

ka044000000kOlyAAE_0EM44000000QAxb.png

ACTION
This issue has been resolved in Strategy 10.9 and 10.4 Hotfix 5. Upgrade to the latest platform release or feature release version to take advantage of the fix.
WORKAROUND
Disable the "Synchronize user/group information with LDAP during Windows authentication" option when using warehouse pass-through authentication with Kerberos.
  KB439206


Comment

0 comments

Details

Knowledge Article

Published:

December 27, 2017

Last Updated:

January 4, 2019