Just to validate things, is the Connector in that VNET (10.0.1.0/24)? The Connector needs to be able to access 10.0.1.4 to be able to Connect your to that Resource.
What activity do you see for that Resource in the Admin Console?
You may want to enable Connector logs so you can see what’s happening at the Connector.
If the Connector is on the same virtual network as the SQL DB server you shouldn’t have to create a private endpoint. IIUC, VMs in the same virtual network should be able to talk to each other and as long as the Connector can reach your DB, it should work.