I have vNet1 (in south central US region) with Virtual network gateway configured with Point to Site VPN. Azure SQL has been deployed within the same vNet with private endpoint (all public access blocked.) i am able to access the Azure SQL via ssms via Azure VPN.
I have another Azure SQL with private endpoint (all public access blocked.) deployed in vNet2 (in north central US region), i just wanted to user can connect to Azure VPN in vnet1 and able to access the Azure SQL in vNet2 from their home location.
I am able to access the Azure SQL in vNet1 via VPN but unable to connect to Azure SQL in vNet2. I have configured vNet to vNet peering (along with gateway transit enable) but unable to access the Azure SQL in vNet2. also set up another Virtual network Gateway in vNet2 and set up vNet to vNet connection but still unable to access Azure SQL in vNet2.
is this possible to get connect to one vnet via vpn and able to access azure sql which is in another vnet?
any help will be highly appriciated.
