Using Azure File Storage and FileVista (web-based file manager)

  1. Create an Azure WS2016 VM with SQL Express (and SSMS) with 1 additional attached data disk; with a Static IP address & Network Security Group Inbound Rules for HTTP & HTTPS. RDP into the VM to add IIS Role and features; add Inbound & Outbound Port 80 & 443 in Windows Firewall.
  2. Install, configure & customize FileVista, after creating the new website.
  1. Create and prep the Azure 2016 Webserver VM
  • RDP into the Webserver VM created in Step 1.
  • In SSMS, create a new empty database called FileVista:
  • Security > Logins > New Login… > General tab > select SQL Server Authentication
  • User Mapping > Map to FileVista db
  • Role Membership for FileVista > select db_owner
  • This Login will be used while configuring FileVista to be able to connect with SQL Server
  • Create a new directory ‘virtualhosts’ on the data drive and a folder within that is named FileVista, to install the FileVista program into, since we prefer to install websites only on an attached data drive, and NOT use the default inetpub folder on the C drive that IIS sets up.
  • Download & Install FileVista, choosing the E:/virtualhosts/filevista path when asked where to install the files (i.e. NOT in the C:/inetpub default location.)
  • Configure FileVista in the web browser:
  • Path = UNC path to the Azure Storage File (This can be found on the ‘Connect’ blade of the File Storage Account in Azure Portal, eg.\\demostorage.file.core.windows.net\data )
  • User name = Storage Account Name
  • Pwd = One of the Azure Storage Account’s Access Keys
  • Root Folders now contains an authorized link into the Azure File Storage container.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store