Configuring the Microsoft SQL database for QVscribe Core Service

To create and setup the database and user for QVscribe follow these steps:

1. Login in to Microsoft SQL as a database administrator.
2. Replace the default password 'replace_me' in the script file create_db_sqlserver.sql with a password of your choice.
3. Execute the updated script file create_db_sqlserver.sql.
• The script creates a database with the name ‘qvscribe’ and a user with name ‘qvscribe_user’ with the password chosen in step 2. The script also assigns db_datareader and db_datawriter roles to the user ‘qvscribe_user’ on the database ‘qvscribe’.
4. Execute the script create_tables_sqlserver.sql with a user having sufficient rights.
5. Execute the script insert_trigger_word_categories_sqlserver.sql with a user having sufficient rights.

To set up an ODBC connection

1. Ensure the ODBC driver has been updated as specified in the prerequisites section above.
2. Create a 32-bit ODBC connection with a System DSN with DSN name `qvscribeDS’ to the initialized database.
3. Change the default database in the DSN connection to ‘qvscribe’.

To configure connectivity to the database server:

1. Open a text editor as administrator and edit the configuration file: QvsCoreWindowsService.exe.config located in the folder: C:\Program Files (x86)\QRA Corp\QvsCore\
2. Locate the ‘userSettings’ section in this file and update the value of the setting ConnectionString by replacing the password ‘replace_me’ with the password created in step 2 of section 5.1.1.

<userSettings>
<QvsCoreRestLib.Properties.Settings>
<setting name="ConnectionString" serializeAs="String">
<value>DSN=QVscribeDS;uid=qvscribe_user;pwd=replace_me;MARS_Connection=yes
</value>
</setting>
</QvsCoreRestLib.Properties.Settings>
</userSettings>

To modify the port where the QVscribe service runs (optional):

1. Using a text editor, open QvsCoreWindowsService.exe.config located in ‘C:\Program Files (x86)\QRA Corp\QvsCore\’ and find the following lines:
• <add baseAddress="http://localhost:8733/QvsCore/v1/RequirementAnalyzerService/" />
• <add baseAddress="http://localhost:8733/QvsCore/v1/TriggerWordService/" />
• <add baseAddress="http://localhost:8733/QvsCore/v1/AnalyzedRequirementService/" />
2. Change the port in the three lines from 8733 to a free port of your choice and save the updated file.
3. Finally, configure the firewall on the server where QVScribe Core Service is running such that the port (8733 by default) is accessible.

These changes will take effect when the QVscribe Core Service is restarted.