Connect the Software to the SQL Server

Connect Your Group to the SQL Server

  1. Open the software to the main menu using an administrator account.
  2. Open the group properties:


  3. Keep note of the table name displayed at the end of the existing settings box and then select ‘Configure’:


  4. Select ‘OLE DB: Connection String’ from the Database Type drop-down menu then select ‘Build’:


  5. Select ‘SQL Server Native Client 10.0’ and then select ‘Next’:


  6. Select the server name from the drop-down box; use the option that includes the server instance name. Enter the username and password settings you chose earlier. Select the database from the list and select ‘OK’:


  7. Set the login/password information, select the table name that was recorded from the settings menu previously, and then select ‘OK’:


  8. Select ‘Yes’:


  9. Select ‘No’:


  10. Select ‘Yes’:


  11. Select ‘Ok’ and setup for this group is done:


  12. Repeat steps 2-11 for each group that you have in the software.

Previous Steps

Manually Installing the SQL Server (Jolly Server)

Installing the default Jolly Server (Basic Installation)

Importing Data from the Internal Jolly Server (Microsoft Access)

Have more questions? Submit a request


Powered by Zendesk