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.
- 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.
- On the system where your Microsoft SQL Server is installed, select Microsoft SQL Server 2014, or Microsoft SQL Server 2012. ,
- Select SQL Server Management Studio.
- In the Object Explorer pane, connect to an instance of the SQL Server Database Engine, and then expand the node for that instance.
- Right-click Databases and select New Database.
- In the Database name text box, enter a name, using ASCII characters only, for the database you are creating for JMP Server.
For example: JMPDBImportant: Non-ASCII characters are not supported.
- Use the default values for the Initial size and Autogrowth parameters for the database and log files.
- Click OK.
SQL Server Management Studio adds your database to the Databases folder in the Object Explorer pane.
- 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.