Views:

Purpose: This article describes how to create and configure a SQL database for use with EasyMatch QC.

 

WarningImportant Notes
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.

  1. Execute the EZMQC.sql script file and the EasyMatch QC SQL database will be created.

  2. You can use the SQL Server to view this database and see that tables have been created within it.

  3. In the TREE VIEW, expand the SECURITY BRANCH.

  4. Right-click on SECURITY > LOGINS and choose NEW LOGIN.

  5. 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

  1. Close SQL Server.

  2. On the computer where EasyMatch QC will be run, open EasyMatch QC.

  3. Select SYSTEM CONFIGURATION > OPTIONS, and then DATA STORAGE. The Data Storage Screen appears.

  4. 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 username and password. When SQL Server option is selected, the database server credentials need to be specified.

Note: When the 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.

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

For more detail see the attached document.

Do you still need more information? Submit a ticket and our support team member will reach out to you soon!
 

 

 

Keywords: EasyMatch QC, Accessories, SQL Database, Database

Related Attachments (1)