Zumero


Zumero for SQL Server: Installation on Azure


1. About

2021-03-18 11:06:38

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. Configure VM Networking

In order for the Zumero Server to be able to talk to clients, you will need to create a firewall rule to allow access to that port.

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

  2. Select Networking from the menu.

  3. Ensure Inbound port rules is selected and click Add inbound port rule

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

    • Source: Any

    • Source port ranges: *

    • Destination: Any

    • Destination port ranges: 8080

    • Protocol: TCP

    • Action: Allow

    • Priority: (accept generated value)

    • Name: Zumero

  5. Click the Add button to create the rule

4. Connect to the Virtual Machine

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

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

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

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

8. Azure AD authentication

ZSS Server can use credentials from Azure Active Directory to connect to Azure SQL databases, if the database has been configured to allow such authentication. More information on deploying Azure AD and Azure SQL Ad integration can be found in the following documentation:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure?tabs=azure-powershell

ZSS Server supports the Azure Active Directory - Password and Azure Active Directory - Integrated authentication methods. The ZSS Server Configuration Utility can be used to configure your ZSS Server to connect via these methods.

ZSS Manager can also use Azure Active Directory credentials, more information on that can be found in the ZSS Manager Documentation.