Skip to main content

KFS Fixpack 8 cannot be installed, because DB schema is not dbo

Article # 3032462 - Page views: 79


Latest KFS FP cannot be installed due to DB Schema is unequal to "dbo".

How can I change DB schema for KFS database?




1.) ALTER SCHEMA NewSchemaName TRANSFER OldSchemaName.ObjectName -> (please notice that ALTER SCHEMA must be done per DB object (Table, SP orView))

2.) User must have appropriate permission to DB

3.) run the KFS SP or FP update

4.) keep dbo schema or change back to old schema, steps are the same as in 1.)


How to change schema of all tables, views and stored procedures in MSSQL:



Level of Complexity 



Applies to  

Product Version Build Environment Hardware
KFS 4.3      


Add any references to other internal or external articles


Article # 3032462
  • Was this article helpful?