Table of Contents
This document explains how to use Zumero for SQL Server (ZSS) with the Microsoft Azure cloud computing platform.
Using ZSS Server with an Azure SQL Database requires the creation of an Azure Virtual Machine to host the ZSS Server.
It is assumed that you already have an Azure account and are able to access the Azure Portal.
First you'll need to create a new virtual machine to host the ZSS Server. Any of the version of Windows Server supported by Azure will work with ZSS Server.
Instructions for creating a new virtual machine can be found in the Azure Documentation
In order to expose the port on which the ZSS Server will run, you will need to create an endpoint for that port.
Click on the name of your new virtual machine, this will bring up the information page.
Select Endpoints from the menu.
Click Add at the bottom of the page.
Select Add a Stand-Alone Endpoint and proceed to the next page
Specify the following details: (using port 8080 in this example)
Public Port: 8080
Private Port: 8080
Click the checkmark to continue.
Connect to your virtual machine via Remote Desktop using the process described in the Azure Documentation.
Before you install ZSS Server, IIS must be installed on the machine. To do this you must add the "Web Server" role to your server.
Instructions for adding a role can be found in Microsoft's Server Manager Documentation.
The ZSS Server runs on an alternate HTTP port (8080). A new firewall rule must be created to allow external connections.
On your virtual machine, open the Windows Firewall control panel item.
In the left pane, click Advanced Settings
In the Windows Firewall with Advanced Security dialog box, in the left pane, click Inbound Rules, and then, in the right pane, click New Rule.
In the New Inbound Rule Wizard dialog, select port, then click the next button.
On the next page of the wizard, ensure TCP is selected, then enter 8080 in the text field next to Specific local ports, then click the next button.
On the next page of the wizard, ensure Allow the connection is selected and click the next button.
On the next page of the wizard, ensure Domain, Public, and Private are checked and click the next button.
On the next page of the wizard, name the new rule Zumero and click the Finish button to create your rule.