The error "System.Runtime.InteropServices.COMException" appears when trying to copy a SQL Server database over an existing database.
Steps to reproduce:
1. Open Toad for SQL Server and connect to the database.
2. Select the Database to copy.
3. Set the destination database (make sure it already exists in the database)
4. Set the database file name (make sure it already exists in the database)
5. Check "Overwrite any existing files"
6. Go
********************************************************************************
Exception Information
********************************************************************************
Exception: System.Runtime.InteropServices.COMException
Message : Retrieving the COM class factory for component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154.
Stack Trace:
at Quest.Toad.SqlServer.Doe.CopyMoveDBWizard.Objects.Server.GetResultConnectionToSoursceServer(WizardParams options)
at Quest.Toad.SqlServer.Doe.CopyMoveDBWizard.CopyMoveDBWizard.pageConfigureDTSPackages_CloseFromNext(Object sender, PageEventArgs e)
at Quest.Toad.Controls.Wizard.WizardPage.OnCloseFromNext(Wizard wiz)
at Quest.Toad.Controls.Wizard.Wizard.Next()
at Quest.Toad.Controls.Wizard.Wizard.btnNext_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Messa
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center