Information about the JMP Server services and the JMP assignments that Horizon desktop administrators create are stored in a SQL Server database. You must create this database before running the JMP Server installer.

Note: Using a remote SQL server is useful in cases of host failures.


  • Verify that a supported version of SQL Server is installed on a system that is remote from the host on which you plan to install JMP Server, but is in your network environment. For details, see Database Requirements for JMP Server.
  • Ensure that you use SQL Server Management Studio to create and administer the database. If you are installing JMP Server in a PoC environment, you can use SQL Server Management Studio Express. Download and install it from the following website.


  1. On the system where your Microsoft SQL Server is installed, select Start > All Programs > Microsoft SQL Server 2016, Microsoft SQL Server 2014, or Microsoft SQL Server 2012.
  2. Select SQL Server Management Studio.
  3. In the Object Explorer pane, connect to an instance of the SQL Server Database Engine, and then expand the node for that instance.
  4. Right-click Databases and select New Database.
  5. In the Database name text box, enter a name, using ASCII characters only, for the database you are creating for JMP Server.
    For example: JMPDB
    Important: Non-ASCII characters are not supported.
  6. Use the default values for the Initial size and Autogrowth parameters for the database and log files.
  7. Click OK.
    SQL Server Management Studio adds your database to the Databases folder in the Object Explorer pane.
  8. Exit Microsoft SQL Server Management Studio.

What to do next

Before you install JMP Server, create a SQL Server login for the JMP Server host. See Create a SQL Server Login for the JMP Server Host.