Database Migration Service - Atlas MongoDB

Question

Hi,

I cannot use Atlas MongoDB as a source for a database migration.

The connection fails with the following message:

{ "resourceId":"/subscriptions/resourceeId/resourceGroups/cosmos-resource-group/providers/Microsoft.DataMigration/services/dms-mongo-to-cosmos-v2", "errorType":"Failed to connect, please check error details", "errorDetail":"The connection failed.Only 'authSource' and 'replicaSet' are allowed in a TXT record." }

The same issue happens if i try to connect via Azure Data Factory.

Thanks

Answer 1

Hi Rafael Carinha,

Thanks for reaching out to Microsoft Q&A.

This error is from MongoDB, not from ADF or Azure DMS. There is a previously solved answer including one from MongoDB community forum which can help you resolve this.

https://www.mongodb.com/community/forums/t/atlas-serverless-and-dns-txt-record/117967/9

https://stackoverflow.com/questions/68608923/atlas-mongodb-serverless-and-aws-lambda-connection-issue

Please Upvote and Accept as answer if the reply was helpful, this will be benefitting the other community members who go through the same issue.

Answer 2

Hi Rafael Carinha •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are getting error when connecting to Atlas MongoDB with error "The connection failed.Only 'authSource' and 'replicaSet' are allowed in a TXT record".

Please refer to https://learn.microsoft.com/en-us/azure/data-factory/connector-mongodb-atlas?tabs=data-factory and Specify the driver version to 2.19.0 which supports MongoDB version 3.6 and higher. For more information, go to this article.

If you have already referred to the below articles and could not get solution, I would request you to let us know so that we could for other options to unblock you:

https://www.mongodb.com/community/forums/t/atlas-serverless-and-dns-txt-record/117967

https://intellij-support.jetbrains.com/hc/en-us/community/posts/4831340877202-Can-t-connect-to-MongoDB-atlas-serverless-instance

https://stackoverflow.com/questions/68608923/atlas-mongodb-serverless-and-aws-lambda-connection-issue

Awaiting your reply. Thanks