Saturday 8 February 2020

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