We have a synapse workspace configured with Private endpoint. We want to deploy a stored procedure in Synapse built-in sql via azure devops. The script is in our repo and I have created a release pipeline.

The release pipeline is having 2 tasks. One is to deploy artifacts to synapse workspace. Second one is create stored procedure in built-in database.

For second one, I am using ‘Azure SQL database deployment’ task and provided built-in server name and SQL script.

However the second step fails with below error:

A network-related or instance-specific error occurred while
establishing a connection to SQL Server. The server was not found or
was not accessible.

Since Synapse has private end point, we are using devops self-hosted agent and are able to deploy Synapse code, I am assuming it should be able to access built-in SQL as well.

Can someone please help any guidance on this.