How to enable FileBound Demo Mode to Sign on a System that has an Expired License

Enable FileBound Demo Mode to Sign on a System that has an Expired License

Customer was unable to sign in to their test site after their license expired.  Put the site in demo mode and requested a new license key. 

  1. Go to MS SQL Server Management Studio and navigate to the FileBound database.
  2. Go to the OPTIONS table and cut the contents of the LICENSE and VERSIONING columns and paste them to Notepad. Make sure these two columns are blank in the OPTIONS table.
  3. Go to the SETTINGS table and cut the contents of the LICENSE and VALIDATION CODE columns and paste to Notepad. Verify they are blank.
  4. Now attempt to sign on. You should be able to sign on; however the site will be in demo mode.  You will need to reapply your license key and validate it to return to full functionality. 

Note: SQL commands to clear LICENSE & VERSIONING in OPTIONS table and LICENSE & VALIDATIONCODE in SETTINGS table.

Update Options set License = '' , Versioning = '';

Update Settings set PropertyValue = '' where PropertyKey = 'License'

Update Settings set PropertyValue = '' where PropertyKey = 'ValidationCode'

SQL commands to view the contents of these properties:

SELECT License,Versioning
FROM FBDataBaseName.dbo.Options;
Select * from FBDataBaseName.dbo.settings order by PropertyKey desc;