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