How can I get the AZ managed instance to use domain credentials as a "control" account to access a file share?

Question

We need to be able to access file shares from SQL Server Managed Instance for both SSIS and data import tasks.

 

The networks and virtual networks appear to be configured correctly as we’re able to use the Import Flat File task to enter the UNC path for the file share.

 

What we’re stuck on is how to configure authentication, the credentials for the managed instance are non-domain but the file share we are accessing is in our domain, we know it can see the file share, as it asks for credentials but we want a control account that the MI uses that automatically has access to the file share on prem

Would we need to use entra to create a set of credentials that can access both our on prem file share and the managed instance in azure?

 

We’re also having difficulty with Linked Server access from the MI to on-prem SQL Server, inbound/outbound rules for the default port exist in the NSG but we’re still receiving errors regarding the network resource not found.

 Any ideas would be much appreciated