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

Product:TIBCO Spotfire Web Player
Versions:All

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

Details:
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)

 

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.