Besides creating a SQL Server login for the JMP Server host machine, the Windows user account that you plan to use to install the JMP Server instance must be created. This Windows user account must be given sysadmin and database owner privileges in the SQL Server database that you created.
- Log in to a SQL Server Management Studio session as the sysadmin (SA) or use a user account with SA privileges.
- In the Object Explorer pane, connect to the SQL server instance that you created for the JMP Server.
- Create the SQL Server Login for the Windows user account you plan to use for installing the JMP Server.
- Expand the Security folder, right-click Logins, and select New Login.
- In the Login - New dialog box, click Search.
- In the Select User or Group dialog box, select the valid Active Directory user that you plan to use to install JMP Server.
- In the Login - New dialog box, under Select a Page, choose Server Roles and select the sysadmin check box.
- Click OK to close the Login-New dialog box.
- Grant permissions to the Windows user account.
- In the left pane, click Databases.
- Select the database you created for your JMP Server instance, click Security, and then click Users
- In the Users pane, right-click your Windows user login, and select Properties from the contextual menu.
- Under Database role membership, select db_owner role.
- Click OK.
The new login is added under the Logins folder in the Object Explorer pane.
What to do next
Install the JMP Server instance using the information in Install JMP Server.