Hi @Ashash12 ,

You need to have proper network connectivity to your on premise SQL Server. 

As they stated in the docs - connector supports SQL Server on-premises using Azure ExpressRoute and AWS Direct Connect networking

https://docs.databricks.com/aws/en/ingestion/lakeflow-connect/sql-server-pipeline

"The SQL Server connector supports Azure SQL Database, Azure SQL Managed Instance, and Amazon RDS SQL databases. This includes SQL Server running on Azure virtual machines (VMs) and Amazon EC2. The connector also supports SQL Server on-premises using Azure ExpressRoute and AWS Direct Connect networking"