Access data on VM or Premise server using Azure RemoteApp

Setup Scenario:  
1. We have a premise (local) server with shared folders that contain word and excel docs.
2. We have a Azure RemoteApp configured, well almost configured its not working the way we want it.
3. We successfully created a VPN connection between our  premise (local) network and Azure. The two networks are now talking to each other and we can ping and rdp to computer from either side.

Q. We want to setup a remoteapp that fires up word or excel and allows us to get to our on premise (local) local file server shared folder so that we can edit the files . Is that possible.?

We are new to Azure so thank you for your help.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

btanExec ConsultantCommented:
It should be possible in your use case which I see it as hybrid Azure. A hybrid deployment with RemoteApp servers are joined to your AD hence below are minimally what you need to access internal resources e.g.
- For actual Windows domain logon (not Microsoft Accounts), provide domain join credentials and set up Azure Active Directory Sync (DirSync);
- For actual internal access, conduct Azure vNet design with VPN connectivity. Provide a gold image on-premises, upload it to the RemoteApp service and maintain that image regularly;

With this, I believe you already done so, you can consider giving users in your hybrid deployments, the access to designated internal storage provisioned and configured as regular shared folders or DFS. Likewise using the typical logon scripts or GPO to also map drive letters upon their login. The files should be able to reach for further editing etc. Do note the the port to allow in your Firewall too, e.g. by default most network firewall will block port 445, which is required for file and print sharing.

As for the run through of this use case, maybe this blog sharing may help (which you will have done that too) 

Using SMB 2.1 supported in Azure should make file sharing compatible for those editing etc. There is some other means using NET USE as well (in case the file share via explorer fails)
There are commands to create a file share, make directories in the file share, upload and download files, delete files and list files and folders. Or you can connect to a VM in the same region and mount the file share with the NET USE command (NET USE Z: \\[STORAGE_ACCOUNT_NAME]\[SHARE _NAME] /u:[STORAGE_ACCOUNT_NAME] [STORAGE_ACCOUNT_KEY] ) — the Explorer tool for mapping network drives won't work — and then work with the file share like any other drive.
It also stated limitations which is more of the Azure blob and file handling that may be good to be aware as well if the instance is going to have some file sync btw instance too...
You can't copy data across from blobs on Azure, although Microsoft said it might consider this in the future. Similarly you can't get data into your Azure Files storage by shipping a disk to Azure using the import service that Microsoft offers. Unless you want to do it all in PowerShell, you need to connect to the file share via Remote Desktop and copy your files in that way or use the AzCopy utility.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vanyabAuthor Commented:
Thank you btan for your response.  Its a lot of material.   I need a chance to read it all and get back to you.

Thank you
vanyabAuthor Commented:
Thank you for your comment. We abandoned the Azure solution and went with a local RDS solution.  We installed RDS Roles and Features locally  and then published RemoteApp and shortcuts to shared network folders.

thank you again...for your comments and sorry for the long delay in slammed with other priorities
btanExec ConsultantCommented:
no worries, thanks for sharing
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Cloud Computing

From novice to tech pro — start learning today.