Search code examples
azureazure-data-factory

Microsoft Integration Runtime Configuration Manager Failed to connect to the database. Error message: Bad JSON escape sequence:

I have successfully configured Self-Hosted Integration Runtime in Azure Data Factory on Azure Portal as well as Self-Hosted IR Node on my local machine and linked service connects successfully to my local sql server from Azure Portal enter image description here

but when I test connection within IR connection manager on my local machine to connect to local sql server it gives me this error

enter image description here

can anyone help

Solution

  • The problem is Server name with single back slash. I copied Server name from ssms which uses 

    R\SQLEXPRESS

    but then i checked the connection string that Self-Hosted on Azure is using to connect to on premise SQL Server it uses double back slashes 

    R\\SQLEXPRESS

    and after changing to double back slash it works enter image description here