Moving database and changing connection method
Article # 3037501 - Page views: 33
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