Moving database and changing connection method

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