I am new to Azure. I am currently exploring Azure Synapse. I have a local SQL Server Express database on my laptop and I wanted to connect it as a data source on my Azure Synapse. I selected SQL Server:

Now when I tested the connection I get the following error:

The problem is I get a 22300 error:

Cannot connect to SQL Database: 'DESKTOP-xxxxxx\SQLEXPRESS', Database: 'David', User: 'Bidi'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified), SqlErrorNumber=-1,Class=20,State=0,
Activity ID: eafe37de-fabf-43d6-914f-25e8685bb149.

I even tried enabling the port in the SQL configuration manager:

And I made a firewall rule to allow the port:

Unfortunately I still can't get the linked service on Synapse to connect to it.

Any help would be greatly appreciated.

CodePudding user response：

You will need to install the Self-hosted integration runtime in your on-premises network, for example on the machine running SQL server:

A self-hosted IR is capable of:

Running copy activity between a cloud data stores and a data store in private network.

See the docs on how to install and configure the runtime .