---
title: "How to modify the license key name and site code in the Pharos database"
slug: "how-to-modify-the-license-key-name-and-site-code-in-the-pharos-database"
updated: 2024-04-03T06:51:14Z
published: 2024-04-03T06:51:14Z
canonical: "kb.pharos.com/how-to-modify-the-license-key-name-and-site-code-in-the-pharos-database"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pharos.com/llms.txt
> Use this file to discover all available pages before exploring further.

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

1. If running a full version of SQL Server, follow these steps:

update system

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

where:

new license key name = license key name

new site code = sitecode01
  1. Start the SQL query analyzer.
  2. Select the pharos database.
  3. Run the following script:
2. 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).