Horizon JMP Server utilizes Microsoft SQL Server to store critical configuration data and JMP Assignments, which is the term used for combined resources you entitle using the JMP Server. The following versions of SQL are supported:

• SQL Server 2012 (SP1, SP2, SP3, and SP4)
• SQL Server 2014 (SP1 and SP2 with CU7 or later)
• SQL Server 2016 (SP1 with CU6 or later)

The database must be created prior to installing the JMP Server software. The following are the general requirements of the JMP Server database:

• The database name must not contain non-ASCII characters.
• You should determine whether your SQL Server supports SSL connections, as this is a JMP Server configuration option.
• Use the default values for the database and log file Initial size and Autogrowth.
• You may use either SQL Server authentication or Windows authentication for the database, and grant the account the following permissions:
  • The examples provided in this chapter will use a SQL account named svc-jmp and a database named jmpdb.
  • The account must have db_owner permissions in the target database.
  • The account must hold the sysadmin role on the hosting SQL Server instance.
• The JMP Server database should be backed up using a similar schedule to your Horizon pod and App Volumes Manager Server.

Consult the Microsoft SQL Server documentation (https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation) for additional information about creating databases and SQL user accounts, and granting access to SQL server instances and databases.