Failed to connect to the database. Error message: bad JSON escape sequence: \S.

We recently upgraded one of customers from NAV2016 to BC Cloud.

One of the critical step in this upgrade is to move data from BC OnPrem to BC Cloud using Intelligent Cloud/Cloud Data Migration using “Microsoft Integration Runtime Configuration Manager” tool.

We got below error while testing the Connection to the database in tool.

Failed to connect to the database. Error message: bad JSON escape sequence: \S. Path ‘properties.ConnectionString’, line 5, Position 78

Solution: Make sure to use 2 back slashes in your SQL Server details.

We used 1 back slash in above image as CD-NavToBC\SQL2016

But it should be CD-NavToBC\\SQL2016

Dynamics 365 Webinar: Progressus ERP for Small & Mid-sized Professional Services Companies

Our #ProfessionalServicesAutomation and ERP software spans all your critical business functions:

- resource management

- project management

- project accounting

- sales & marketing

- financial management

Find out if Progressus is right for your business:

https://www.velosio.com/blog/2018/04/10/dynamics-365-webinar-progressus-erp-small-mid-sized-professional-services-companies/