Hello, There are technical/virtualisation reference guides as part of the Technical Architect Certification training path that will be relivant to this, there is also an Azure guide on the portal (go to docs and search for Azure). I am guessing the solution of how to do what you are attempting will be spread in information across these seperate guides.
The Azure guide does what you are trying to do n reverse (the SQL Server is in Azure and the resources are local as opposed to your attempt to have the SQL Server local). However, the assumptions from the document might point you in the right direction: "a connection is in place between the Blue Prism network and any external networks where the automated applications reside. This may be via a VPN, internal Vnet Peering (for cloud hosted applications) or Express Route".
------------------------------
Denis Dennehy
Head of Customer Success, EMEA
Blue Prism Ltd
Europe/London
------------------------------