Skip to main content

Connecting Sun Nuclear Daily QA 3 versions 3.1.1 and above

David Kirkaldie
  • Updated

This article covers the following topics:

Prerequisites

Below are the pre-requisites to connect the Daily QA 3:

  1. To use daily QA devices, you must have the latest Equipment Hub installed. Instructions on how to install the Equipment Hub can be found here.
  2. There must be a current maintenance license and decryption key installed in order to exports results out of the Daily QA 3 database.
  3. The SQL database for Daily QA 3 software is present and functioning correctly.
  4. A user must be established for the Equipment Hub to connect to the Microsoft SQL database. The directions are different depending on the login method; complete either Windows Authentication or SQL Authentication depending on your environment.

Decryption Key

The Sun Nuclear DQA3 software and database are encrypted by default, beginning with version 3.1. The Equipment Hub cannot read the encrypted database. Users can request a decryption key from Sun Nuclear, and this decryption key will be added to the license manager for the DQA3 software.

The effect of the decryption key is to write the measurement data into unencrypted tables in parallel to the encrypted tables. Note that previously encrypted data cannot be decrypted. Equipment Hub can only read data measured while the decryption key is in place.

Windows Authentication

The steps below use the SQL Server Management Studio (SSMS) as an example. The same steps can be taken with other tools.

  1. In the SSMS, right click the server object, select properties, click the Security page, select the “Windows Authentication mode” radio button, and click ok:  WinAuth_001.png
  2. Open the Services applet and restart the SQL server:  Win-SQL_Auth002.png
  3. In the SSMS, expand the server object’s Security and Logins folder:  Win-SQL_Auth003.png
  4. Right click the Logins folder and click on New Login:  Win-SQL_Auth004.png
  5. Select the General page, give the existing user's name and use the search button to select it Select the “Windows authentication":  WinAuth005.png
  6. Select the “User Mapping” page, click the DailyQA check box under “Users mapped to this login”, under “Database role membership for: DailyQA” select the PHYSICIST_ROLE and click OK. Win-SQL_Auth005.png
  7. Create a new or edit an existing Daily QA3 device in and ensure that the “Version 3.1.1 or newer” is set to yes, set the “Database Name” to DailyQA, set Server to the name of the SQL server object, set “Integrated Security” to yes, and click “Sign and update device”. Win-SQL_Auth007.png
  8. Fill out the rest of the fields as normal.

SQL Authentication

The steps below use the SQL Server Management Studio (SSMS) as an example. The same steps can be taken with other tools.

  1. In the SSMS, right click the server object, select properties, click the Security page, select the “SQL Server and Windows Authentication mode” radio button, and click ok:  SQL_Auth001.png
  2. Open the Services applet and restart the SQL server:  Win-SQL_Auth002.png
  3. In the SSMS, expand the server object’s Security and Logins folder:  Win-SQL_Auth003.png
  4. Right click the Logins folder and click on New Login:  Win-SQL_Auth004.png
  5. Select the General page, give the new login a name (Test in this example), select the “SQL Server authentication, fill out both password fields, and uncheck ”Enforce password policy” (as we are logging in from Equipment Hub we don’t want a forced password change):  SQL_Auth005.png
  6. Select the “User Mapping” page, click the DailyQA check box under “Users mapped to this login”, under “Database role membership for: DailyQA” select the PHYSICIST_ROLE and click OK.  Win-SQL_Auth005.png
  7. Create a new or edit an existing Daily QA3 device and ensure that the “Version 3.1.1 or newer” is set to yes, set the “Database Name” to DailyQA, set “Database user” to the name of the newly created user, set “Database password to the password for the user you created, set Server to the name of the SQL server object, set “Integrated Security” to no, and click “Sign and update device”.  

    SQL_Auth007.png

Daily QA 3 Configuration

Before performing this configuration ensure that the SN DQA3 database is installed and functioning correctly. In the software, the DQA3 will need to be set up from the “Manage - Measurement Devices” page.

  1. Navigate to the "Manage - Measurement Devices" and edit the device created in the prerequisites section.
  2. Click the Active radio button.
  3. Optionally add a description in the "Device description" field.
  4. Optionally add the serial number for the DQA3 in the "Serial Number" field.
  5. Select the correct Equipment Hub service from "Equipment Hub" drop down menu.
  6. Click the Update Device button
  7. Navigate to the "Manage Schedule Configurations" page. Select the schedule that the DQA3 device will be used with and click the pencil icon button for that schedule.
  8. Under the "X-Ray output constancy" section, pick the correct Equipment Hub from the first drop down menu.
  9. Under the "X-Ray output constancy" section, pick the correct measurement device from the second drop down menu.
  10. Under the "Default Energies" section, select the checkbox for each energy used for the QA device and enter the correct energy in the associated text box. For energies with the same numerical value but different dose rates (e.g. SRS) this may have been setup as multiple rooms in your DQA3 database.
  11. Repeat steps 9 through 11 for the "Electron output constancy" section
  12. If not all fields will be imported, they can be deselected. Expand the sections at the bottom of the schedule settings and deselect any unused fields as shown below: mceclip0.png
  13. Tolerances are pulled from the Daily QA 3 database, however, these may be overridden. To do so, navigate to the "Manage Schedule Configurations" page, hover over the schedule that the DQA3 device will be used with and click the Tolerances button for that schedule. Set and update the baselines and tolerances as needed.

Troubleshooting

Please see the following articles to troubleshoot common problems:

Related articles

Comments

0 comments

Please sign in to leave a comment.