To create and setup the database and user for QVscribe follow these steps:
- Login in to Microsoft SQL as a database administrator.
- Replace the default password 'replace_me' in the script file create_db_sqlserver.sql with a password of your choice.
- 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’.
To set up an ODBC connection
- Ensure the ODBC driver has been updated as specified in the prerequisites section above.
- Create a 32-bit ODBC connection with a System DSN with DSN name `qvscribeDS’ to the initialized database.
- Change the default database in the DSN connection to ‘qvscribe’.
To configure connectivity to the database server:
- 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\
- 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.
<setting name="ConnectionString" serializeAs="String">
To modify the port where the QVscribe service runs (optional):
- 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/" />
These changes will take effect when the QVscribe Core Service is restarted.