For companies where their SQL Team does not allow database applications to create their own databases, the following steps will be required in order to manually create the RayQCAdvanced database before the MSI installation is run.
1. Create a new database.
2. Run the attached ‘SqlGenerator.sql’ file against that database.
3. Run the attached ‘SQLInitializationData.sql’ file against that database.
4. Run the following query against that database:
INSERT INTO AppConfiguration (Property, Value)
VALUES ('DatabaseSchema', '4.1')
5. Run the attached 'RayQCAd_Users.sql' file against that database. Change DATABASENAME to the name of the database beforehand!
6. Decide on which authentication method to use to access that database, and then either create a single SQL login or as many Windows logins as there will be RayQC users. Their user mapping within that database should be to the RayQCAd_Users database role.
7. Execute the ‘RayQCAdv_4.1.4268.61.msi’ file along with the attached MST file. If SQL authentication was chosen in step 6, then that SQL login should be entered within the relevant wizard dialog, along with the existing database name (if the database is detected correctly, clicking next should display the next wizard dialog; if not, a pop-message will appear stating that a new database will be created which is not what you want to happen). The user running the MSI install must have at least db_datareader permissions to the database.
Note1: The sql file mentioned in steps 2 & 3 were obtained by performing an administrative MSI installation.
Note2: In a future version of RayQCAdvanced, a new MSI dialog will be available allowing you to utilise an existing database, thus removing the need of the attached MST file.