Azure SQL Managed Instance Connectivity Issue

Hi Reddit,

I have a VNET in Azure that connects to my on-premises network via Azure VPN Gateway. I have a peering setup between this VNET and another VNET in Azure where my SQL Managed Instance is, and a windows VM as well.

I'm able to connect to my windows VM, but for whatever reason I can't connect to the SQL Managed Instance except with a public endpoint. I'm thinking I should be able to connect without the Public Endpoint, but I'm not sure what I'm doing wrong. I can't submit a support request in Azure because I don't pay for that so I'm hoping someone here has maybe encountered something similar and has some advice.

Thanks in advance for any help offered.