Unable to authenticate MongoDB from TIBCO Spotfire Web Player or Automation Services using ODBC Data Provider - "auth failed (Error Code: 11)"

Unable to authenticate MongoDB from TIBCO Spotfire Web Player or Automation Services using ODBC Data Provider - "auth failed (Error Code: 11)"

book

Article ID: KB0072963

calendar_today

Updated On:

Products Versions
Spotfire Web Player All

Description

A connection to MongoDB server using an ODBC Data Provider fails to authenticate from TIBCO Spotfire Web Player or Automation Services with the following error: 
 Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "test3". ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "test3". ---> System.Data.Odbc.OdbcException: ERROR [HY000] [TIBCO][MongoDBODBC] (110) Error from MongoDB Client: auth failed (Error Code: 11) ERROR [HY000] [TIBCO][MongoDBODBC] (110) Error from MongoDB Client: auth failed (Error Code: 11)    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

 

Issue/Introduction

This article briefly describes the steps to authenticate when connecting to MongoDB from Spotfire Web Player or Automation Services using an ODBC data provider.

Environment

All

Resolution

To resolve this issue, modify the DSN by referring to the following steps:
  1. Go to the Node Manager machine(s) and open the ODBC Data Source Administrator.
  2. Open the DSN (highlight the DSN and click configure) that is being used by the MongoDB connection.
  3. Change the Encrypted Password option from 'Current User Only' to 'All Users on this Machine' as shown in the screenshot below. 
  4. Click Test and check if the connection is successful.
  5. Click OK to save the changes.
User-added image
Powered by Wolken Software