HunterLab EasyMatch QC, User Manual

Page: 334 / 366

EasyMatch QC User’s Manual Version 2.1
Creating and Configuring a SQL Database D-1
APPENDIX D
Creating and Configuring a SQL Database
This appendix 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 Sever is typical) should be installed first followed by EasyMatch QC, as described in
the EasyMatch QC Installation Guide.
1. In SQL Server, select Open from the File menu and choose to open the C:\Program
Files\HunterLab\EasyMatchQC\SQL Database Script\EZMQC.sql script file. 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 EZMQC 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 Logins under Security and choose New Login .
6. Change Default Database to EZMQC and do User Mapping to set each User with data read and write
roles for the EZMQC SQL database.