Create and Configure a EZMQC SQL Database Follow

This article describes how to create and configure a SQL database for use with EasyMatch QC.  A working knowledge of SQL server is recommended for performing these steps.  A copy of SQL Server (Microsoft SQL Server) should be installed first followed by EasyMatch QC, as described in the EasyMatch QC Installation Guide

1. In SQL Server, select File > Open and choose to open the script file from the location

         For 32 bit OS: “C:\Program Files\HunterLab\EasyMatchQC\SQL Database  Script\EZMQC.sql”

         (or)

        For 64 bit OS:  “C:\Program Files (x86)\HunterLab\EasyMatchQC\SQL Database Script\EZMQC.sql”

       This is the location of the file if you installed EasyMatch QC to the default folder.  If you installed elsewhere, you will find the SQL Database Script subfolder in your installation folder.

2. Execute the ‘EZMQC.sql’ script file and the EasyMatch QC SQL database will be created.
3. You can use the SQL Server to view this database and see that tables have been created within it.
4. In the Tree View, expand the Security Branch.
5. Right-click on Security > Logins and choose New Login.
6. Change Default Database to EasyMatch QC and set User Mapping for each User with data read and write roles for the EasyMatch QC SQL database.

 Figure 227. Creating an SQL Database

Note: If data is collected using a comma as the decimal separator, please follow these steps after creating the EZMQC tables to update certain columns in the diagnostics table:

• Download the Script File: Script file for Comma as decimal.sql
• Execute the Script:
  • In SQL Server, select File > Open.
  • Choose the downloaded script file.
  • Execute the script.

7. Close SQL Server.
8. On the computer where EasyMatch QC will be run, open EasyMatch QC.
9. Select System Configuration > Options, and then Data Storage. The Data Storage Screen appears.
10. Select the SQL Server, enter the server and database name (EasyMatch QC). Click OK.

Figure 228. SQL Database Storage

When the SQL Database Server is selected, a new option is provided to select the Authentication type as ‘Windows’ or ‘SQL server’ in the Data Storage Dialog.  If ‘Windows’ is selected, the current system user credentials will be used to login to the SQL server. Then there is no need to specify the user name and password.  When ‘SQL Server’ option is selected, the database server credentials need to be specified.

Note: When ‘Windows Authentication’ option is selected in SQL server (local server or network server in a domain), the login security permissions should be added for the configured EasyMatch QC-ER Admin/User groups for EasyMatch QC database in the SQL Server.

11. Restart EasyMatch QC and then SQL Server Database is ready for use.