Search code examples
azureazure-cosmosdbazure-cosmosdb-sqlapi

connection is insufficiently secured Error in Azure cosmos DB Data Migration tool

I am trying to load JSON file data into cosmos DB container using Azure cosmos DB data migration tool but I'm unable verify my database connection when clicked on verify. The error is as follows

enter image description here

I took the 'Primary Connection String' from my Cosmos DB account and appended the database name

AccountEndpoint=https://n0-dev-cdb-01.documents.azure.com:443/;AccountKey=**********;Database=Accounts;

Note: in the Advanced Settings of the Target Information tab I changed connection Mode from DirectTCP to Gateway but still facing the same error.

Your help is greatly appreciated, thank you.

Solution

  • Go to the Networking tab in Azure Cosmos Database, and navigate to Connectivity. Select the TLS 1.0 protocol and save it, as shown below:

    enter image description here

    After updating the protocol, go to the Azure Cosmos DB Migration Tool and use the connection string in the following format:

    AccountEndpoint=<url>;AccountKey=<key>;Database=<db>;

    Verify the connection. It will connect successfully, as shown below:

    enter image description here