Change your customer number or serial code

Note: This applies to a local or on-premises installation only. If you are using ESHA Cloud, please contact Support.

If you find that the customer number shown in the application does not match yours, you have to change it in the Database Utility program, or run a SQL query on the database to remove it.

1. Launch the Database Utility application

2. In the Connect to server... line, choose the proper server name.  This is most likely the local computer name, followed by \ESHA or (localdb)\v11.0   You can check your server name by opening Genesis R&D and going to Home > About.

3. Click the drop-down menu in the screenshot and select the correct database. This will be gendata by default.

4. Click on "Users" and then "Edit serial codes"

5. Change the Customer number and serial code to your correct values.

Advanced:

If you do not have Database Utility you can remove the customer number and serial code from the database SQL.

• Replace the text in curly brackets (e.g. "{paste your serial code}") with your customer number and serial code.
  example:
  update UPreferences set PreferenceValue = 'R2D2-YODA-SOLO-C3PO-R5D4-BOBA-K2SO-JAWA'
  where PreferenceName = 'GenSerialCode'
• Be certain you are executing this SQL against the Genesis database.

update UPreferences set PreferenceValue = '{paste your serial code}' 
where PreferenceName = 'GenSerialCode'
GO
update UPreferences set PreferenceValue = '{your customer number}' 
where PreferenceName = 'CustomerNumber'
GO
select * from UPreferences where PreferenceName = 'CustomerNumber'
select * from UPreferences where PreferenceName = 'GenSerialCode'