Deploying the JAMS Database in Azure SQL

Follow

In JAMS V6.5.54 and higher, the JAMS Database may be deployed in Azure as a Platform as a Service (PaaS) database, also known as Database as a Service (DBaas).

While installing JAMS entirely on a single Azure Server is a nearly identical process to the on-premises JAMS installation, hosting the JAMS Database in an Azure SQL Database with a local server for the JAMS Scheduler requires some small changes to the installation and configuration process.

 

In this topic

 

Back to Top


Configuring the Azure SQL Database

Before starting the JAMS Installation, create a SQL Database in Azure.

  1. In the Database name section, set the Name of the Database. This name must be used later in the JAMS database deployment script.
  2. Set the Subscription and Resource Group options as desired.
  3. In the Select source section, choose Blank Database.
    BlankDB.png
  4. Configure a server for the database. Record the Server name, Server admin login, and Password set here, as they are used in the JAMS database deployment script and must be used to create a JAMS User. 
    NOTE: The full server name URL will be referenced as "ServerName".database.windows.net
  5. Continue defining Azure settings as desired, then Create the SQL Database.
  6. With the Database created, navigate to the Firewall settings and ensure the JAMS Scheduler Server has access to the Azure SQL Server.
    NOTE: If necessary, create Rules to allow communication between the JAMS Scheduler Server and the Azure Server.
    Allow_Azure_Access.jpg

 

NOTE: Do NOT attempt to use a Database Source in Azure.

   

Back to Top


Installation

Installing JAMS with a Database on Azure SQL is very similar to a normal JAMS installation, except that the Database Creation Wizard must be cancelled.

  1. Access the machine where the JAMS Scheduler should be installed.
    NOTE: If JAMS was already installed on this machine, delete the Common.config file, located at C:\Program Files\MVPSI\JAMS\Scheduler\Common.config by default.
  2. Download the JAMS Installer.
    NOTE: JAMS V6.5.54 or higher is required.
  3. Run the JAMS Installer as an Administrator. The JAMS Installation Wizard will appear. Use the wizard to walk through the installation.
    NOTE:
    • This installation requires only the JAMS Client and JAMS Scheduler components.
    • If prompted, install MSMQ. Prompts to install SQL Express can be ignored, as Azure SQL Server will be used.
  4. With the Installer Wizard steps complete, click Finish to begin the installing JAMS Components.
  5. Partway through the installation, the Create a JAMS Database dialog will appear. Click Cancel on this dialog.
    CancelInstallation.png
  6. Confirm the cancellation.
    Cancelconfirm.png
  7. The JAMS installer will continue installing JAMS. When the JAMS installation is complete, Close the JAMS Installer. 

 

Back to Top


Deploying the JAMS Database

  1. Open the CreateAzureDatabase.ps1 script, located at C:\Program Files\MVPSI\JAMS\Scheduler\DbDeploy\CreateAzureDatabase.ps1 by default. 
  2. Edit the first 4 lines of the script to correspond with Azure SQL.
    CreateDBScript.png
    DatabaseName - This will be the name of the Azure SQL Database previously created.
    SQLServername - Enter the URL of the Azure SQL Server previously created with the Azure SQL Database.
    SQLUserName - The Server admin login of the Azure SQL Server created for the JAMS Database.
    SQLPassword - The password for the administrator of the Azure SQL Server.
  3. Save and Close CreateAzureDatabase.ps1.
  4. Run PowerShell or PowerShell ISE as an administrator.
  5. Execute the newly edited CreateAzureDatabase.ps1 script.
    RunDBScript.png
  6. Wait for the script to complete successfully.
  7. If any errors were encountered, open DBUpdate.log for more information. This file is located at C:\Program Files\MVPSI\JAMS\Scheduler\DBUpdate.log by default. 
  8. Users may also access their SQL Database with SSMS to view the newly created JAMS Database.
  9. Close PowerShell.

 

Back to Top


Loading the JAMS Sample Jobs

With the Database Installed, ensure the JAMS Sample Jobs are created.

  1. Open Task Manager on the Scheduler Server, then stop any JAMS Processes. JAMS processes include JAMSServer, JAMSScheduler, JAMSExecutor, and JAMSAgent.
  2. Open the JAMSDBA.exe utility as an administrator. This utility is located at C:\Program Files\MVPSI\JAMS\Scheduler\JAMSDBA.exe by default.
  3. Type in and run the LOAD /INSTALL command.
    JAMSDBA_LOAD_INSTALL.png
  4. Wait until the command is done executing, then close the JAMSDBA utility.
    NOTE: The JAMSDBA> prompt will appear on the second line when the command is done executing.
  5. Open the Windows Services, then Restart all JAMS Services.

 

Back to Top


Creating Folders for JAMS temporary files

Create the Temporary File Folders JAMS requires to run Jobs and save logs.

  1. Within C:\Program Data, create a directory named JAMS.
  2. Within the newly created JAMS directory, create a folder named Logs and a folder named Temp.
    Loglocations.png

 

Back to Top


Additional Reading

Have more questions? Submit a request

Comments