Connect the Software to the SQL Server

Connect Your Group to the SQL Server

Open the software to the main menu using an administrator account.
Open the group properties:
Keep note of the table name displayed at the end of the existing settings box and then select ‘Configure’:
Select ‘OLE DB: Connection String’ from the Database Type drop-down menu then select ‘Build’:
Select ‘SQL Server Native Client 10.0’ and then select ‘Next’:
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’:
Set the login/password information, select the table name that was recorded from the settings menu previously, and then select ‘OK’:
Select ‘Yes’:
Select ‘No’:
Select ‘Yes’:
Select ‘Ok’ and setup for this group is done:
Repeat steps 2-11 for each group that you have in the software.