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

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'

where:

new license key name = license key name

new site code = sitecode01

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'"

   where:

   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).