How to connect to mongodb with a password protected user

[intapiuser]

Introduction

If attempting to connect to MongoDB with a user protected password, but you aren't able to connect to the database through the Simba DSN or the connection string and getting the following error:

Unable to establish a connection with data source. Missing settings: {[PWD]}

Resolution

Please follow these steps:

1. Create a new entry in the DSN as usual

2. Open the Registry Editor

3. Add a string value with name "PWD" to the registry in the following path:

   LOCAL_MACHINE --> Software --> ODBC -->ODBC.INI --> <DSN connecton name>

4. Rename the new field added to the name PWD and enter the password of username