Zumero for SQL Server: Installation on Azure

1. About

2019-10-24 10:05:29

This document explains how to use Zumero for SQL Server (ZSS) with the Microsoft Azure cloud computing platform.

2. Overview

Using ZSS Server with an Azure SQL Database requires the creation of an Azure Virtual Machine to host the ZSS Server.

3. Setting Up the Virtual Machine

It is assumed that you already have an Azure account and are able to access the Azure Portal.

3.1. Create the Virtual Machine

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

3.2. Create an Endpoint

In order to expose the port on which the ZSS Server will run, you will need to create an endpoint for that port.

  1. Click on the name of your new virtual machine, this will bring up the information page.

  2. Select Endpoints from the menu.

  3. Click Add at the bottom of the page.

  4. Select Add a Stand-Alone Endpoint and proceed to the next page

  5. Specify the following details: (using port 8080 in this example)

    • Name: Zumero

    • Protocol: TCP

    • Public Port: 8080

    • Private Port: 8080

  6. Click the checkmark to continue.

3.3. Connect to the Virtual Machine

Connect to your virtual machine via Remote Desktop using the process described in the Azure Documentation.

3.4. Install IIS

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.

3.5. Configure the Windows Firewall

The ZSS Server runs on an alternate HTTP port (8080). A new firewall rule must be created to allow external connections.

  1. On your virtual machine, open the Windows Firewall control panel item.

  2. In the left pane, click Advanced Settings

  3. 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.

  4. In the New Inbound Rule Wizard dialog, select port, then click the next button.

  5. 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.

  6. On the next page of the wizard, ensure Allow the connection is selected and click the next button.

  7. On the next page of the wizard, ensure Domain, Public, and Private are checked and click the next button.

  8. On the next page of the wizard, name the new rule Zumero and click the Finish button to create your rule.

4. Install ZSS Server

Now you are ready to install Zumero for SQL Server on your virtual machine. Simply download and run the installer from our Dev Center.

Additional information on installing Zumero For SQL Server can be found in our installation docs.