Lesson Learned #296:The value of the property '' is invalid: Value does not fall within the expected

[Guest Jose_Manuel_Jurado]

Today, we got an new service request that our customer is facing an error message when testing the connection in a Linked Service to Azure SQL MI from ADF:" The value of the property '' is invalid: 'Value does not fall within the expected range.'. Value does not fall within the expected range. Activity ID: b6e998fa-xxxx-xxxx-xxx"

 

 

 

In this situation, our customer is facing this error from a connection failure from Azure Data Factory to Azure SQL Managed Instance using a System Managed Identity.

 

 

 

Afer some investigations we identified that Managed Private Endpoints was missing after they created and approved it, our customer was able to connect from Azure Data Factory to Azure SQL Managed Instance using a System Managed Identity.

 

Continue reading...