Skip to main content
Kofax

Moving database and changing connection method

Article # 3037501 - Page views: 38

Issue

When moving meta and data databases from one SQL Server to another and moving from SQL to Windows authentication, the Add Existing tab doesn't recognize the existing objects in the schema (dbo) and creates new tables under a new schema.

 

Cause

Windows account may not have db_owner role.

 

Solution

grant db_owner role to the Windows user to these database.

 

Level of Complexity 

High

 

Applies to  
Product Version Build Environment Hardware
Insight 6.x      

 

References

Add any references to other internal or external articles

 

 

 

Article # 3037501