---
title: "Error: 'Pharos is not the database owner' during an upgrade of the Pharos Database."
slug: "error-pharos-is-not-the-database-owner-during-an-upgrade-of-the-pharos-database"
updated: 2024-03-28T12:28:33Z
published: 2024-03-28T12:28:33Z
canonical: "kb.pharos.com/error-pharos-is-not-the-database-owner-during-an-upgrade-of-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.

# Error: 'Pharos is not the database owner' during an upgrade of the Pharos Database.

### Problem:

When running an upgrade of the Pharos Database the following error appeared after starting the upgrade process “Pharos is not the database owner”. The SQL login 'pharos' is the db_owner.Inside the pharos database, the objects are owned by a user role other than db_owner. For our upgrade scripts to work the objects must all be owned by the user role db_owner, and this role should be assigned to the SQL login 'pharos'.

---

### Resolution:

The following SQL query will update the user role ownership of the objects in the Pharos Database. Steps on setting the SQL login as db_owner can be found in a separate FAQ.

USE master

EXEC sp_configure N'allow updates', '1'

RECONFIGURE WITH OVERRIDE

USE pharos

update sysobjects set uid = 1

USE master

EXEC sp_configure N'allow updates', '0'

RECONFIGURE WITH OVERRIDE

There is an update in the latest version of Uniprint that changes how the the account is checked, see [KB Article 2089](https://pharos.custhelp.com/app/answers/detail/a_id/2089).

## Related

- [Error message "No Pharos Print Server configured in Registry" displayed on an Omega device](/error-message-no-pharos-print-server-configured-in-registry-displayed-on-an-omega-device.md)
- [Ability to switch to the GSNX application on some Ricoh devices](/ability-to-switch-to-the-gsnx-application-on-some-ricoh-devices.md)