Updating the QuikData License Key

To update your QuikData license key, you must have direct access to the DRControl SQL database. This change updates a site-level setting and requires a cache refresh in the web application to take effect.

Prerequisites

• SQL Server Management Studio (SSMS)

• Access to the DRControl database

• A valid, updated license key provided by QuikData

Step-by-Step Instructions

1. Update the License Key in SQL

1. Open SQL Server Management Studio and connect to the server hosting the DRControl database.

2. Expand the database and navigate to the table:
   DRControl.dbo.SiteSettings

3. Right-click the table and select Edit Top 200 Rows.

4. Locate the row where:
   SiteSettingKeyEnumValue = 47
   (This value corresponds to the QuikData license key.)

5. Replace the existing value with the new license key provided by QuikData.

6. Click into another row or cell to ensure the change is committed.

2. Refresh the Application Cache

7. Open the QuikData web application.

8. Navigate to:
   Site Admin → Site Settings

9. Click Refresh Cache.

   ⚠️ No confirmation or alert will be displayed — this is expected behavior.

3. Verify the Update

10. Navigate to My Rooms.

11. Confirm that the license expiration warning is no longer displayed.

Notes & Tips

• The license change will not take effect until the cache is refreshed.

• If the alert persists, confirm:

  • The correct row (SiteSettingKeyEnumValue = 47) was updated

  • The cache refresh was performed

  • The license key was pasted without extra spaces or line breaks