connect azure to MongoDB

Reut Cohen 6

I'm trying to connect MongoDB to Azure

I'm using integration runtime

User's image

but I'm getting error once I'm checking the connection

The operation failed with server error. ConnectionId: '{ ServerId : { ClusterId : 1, EndPoint : "Unspecified/eks-stg-shard-00-01.yufxk.mongodb.net:27017" }, LocalValue : 4, ServerValue : "8002" }'.
Command dbStats failed: not authorized on cy to execute command { dbStats: 1, scale: 1, $db: "cy", lsid: { id: UUID("80757c1c-cf6a-4b05-a09f-8509f792bb72") } }.

PRADEEPCHEEKATLA-MSFT 76,836 Reputation points Microsoft Employee

2023-01-17T10:01:09.3333333+00:00

Hello @Reut Cohen,

Thanks for the question and using MS Q&A platform.

This error message is indicating that the Azure Data Factory is trying to connect to a MongoDB server, specifically to a shard at "eks-stg-shard-00-01.yufxk.mongodb.net:27017", but it is not authorized to execute the command "dbStats" on the database "cy". The error message suggests that the user being used to connect to the MongoDB server does not have the necessary permissions to run that command on that specific database.

To resolve this issue, you will need to grant the appropriate permissions to the user on that specific database in your MongoDB cluster.

Hope this helps.
PRADEEPCHEEKATLA-MSFT 76,836 Reputation points Microsoft Employee

2023-01-19T10:38:12.79+00:00

Hello @Reut Cohen,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.