How to modify the license key name and site code in the Pharos database

Blog Post created by toleary on Aug 7, 2013

A) If running a full version of SQL Server, follow these steps:

1) Start the SQL query analyzer.
2) Select the pharos database.
3) Run the following script:

       update system
       set licenced_to = 'license key name', license_quick_key = 'sitecode01'

       new license key name = license key name
       new site code = sitecode01


B) If running MSDE, follow these steps:

1) Find the user name and password needed to log on to MSDE.  These can be found on the PC where the Pharos Database server has been installed by running 'regedit'.


In the registry, go to:

HKEY_LOCAL_MACHINE\Software\Pharos\Database Server\Database

2) The "User Name" value holds the login name and the "Password" holds the password.


3) Go to the command prompt, and do a change directory to the \Binn sub-directory or sub-folder holding OSQL. If MSDE was installed at C:\MSSQL7  (commonly used default directory) then the OSQL is in the directory C:\MSSQL7\Binn.


4) Create a batch file with the following command:

OSQL -Uusername -Ppassword -Q"update system set licenced_to='license key name',license_quick_key='sitecode01'"

           user name = username
           password = password
           new license key name = license key name
           new site code = sitecode01

5) Run the batch file (run the command in item 4 in the directory in item 3).