SQL 2005 Management Studio Error

  • Hi,

    I keep getting a "Class Not Registered" error when I try and use the

    Import Export wizard in Management Studio. I've reinstalled it several times but I'm still

    having trouble. Has anybody else seen this? The complete error message is below:

    ===================================

    This wizard will close because it encountered the following error:

    (Microsoft SQL Server)

    ------------------------------

    For help, click:

    http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=...

    ===================================

    Class not registered

    ------------------------------

    Program Location:

    at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfo­s()

    at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInp­uts wizardInputs)

    at Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean fSources, WizardInputs wizardInputs)

    at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)

    at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()

    at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)

    at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)

  • No, I'm using 32bit and I have SP2 installed.

  • I resolved the problem 🙂 A coworker suggested that I run the MDAC Component Checker tool. The results from the MDAC scan showed that I had a mismatch under COM Details for oledb32.dll. I looked in C:\Program Files\Common Files\System\Ole DB and the DLL was there, so I registered it and the problem was fixed!!

    Thanks to everybody who tried to help.

    MDAC Component Checker tool:

    http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply