Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL Server 2005 Management Studio Error

  
   Database Forums (Home) -> Tools RSS
Next:  full text indexes  
Author Message
todd.lowney

External


Since: Jun 30, 2008
Posts: 2



(Msg. 1) Posted: Mon Jun 30, 2008 10:44 am
Post subject: SQL Server 2005 Management Studio Error
Archived from groups: microsoft>public>sqlserver>tools (more info?)
HI,

I keep getting a "Class Not Registered" error when I try and use the
Import Export wizard. I've reinstalled several times but I'm still
having trouble. 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=9....1399.0

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

Class not registered

------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
at
Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs
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)

 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
todd.lowney

External


Since: Jun 30, 2008
Posts: 2



(Msg. 2) Posted: Mon Jun 30, 2008 12:49 pm
Post subject: Re: SQL Server 2005 Management Studio Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Jun 30, 2:40 pm, "Aaron Bertrand [SQL Server MVP]"
wrote:
> How exactly are you launching the wizard?  Are you doing so against a local
> or a remote instance?  Using what authentication method?  What version is
> the server where you are launching the wizard (you can see this in its top
> node in Object Explorer)?  What is the version of your client tools (you can
> see this in Help|About of SSMS)?
>
> On 6/30/08 1:44 PM, in article
> d84c9913-29bb-403d-b645-257a059df... RemoveThis @z72g2000hsb.googlegroups.com,
>
>
>
> "todd.low...@bankofamerica.com" wrote:
> > HI,
>
> > I keep getting a "Class Not Registered" error when I try and use the
> > Import Export wizard.  I've reinstalled several times but I'm still
> > having trouble.  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=...
> > .00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=U­nca
> > ughtException&LinkId=20476
>
> > ===================================
>
> > 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)- Hide quoted text -
>
> - Show quoted text -


I have SP2 on my client tools. The version is 3042. I'm connecting
to a remote server using Windows Authentication. The server version
is 3239. I get the error for when I right click on a [database name]-
>Tasks->Import Data or Export Data. I'm wondering if there is a
registry issue with my client tools install.

 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
Aaron Bertrand [SQL Serve

External


Since: Jun 15, 2005
Posts: 632



(Msg. 3) Posted: Mon Jun 30, 2008 2:40 pm
Post subject: Re: SQL Server 2005 Management Studio Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
How exactly are you launching the wizard? Are you doing so against a local
or a remote instance? Using what authentication method? What version is
the server where you are launching the wizard (you can see this in its top
node in Object Explorer)? What is the version of your client tools (you can
see this in Help|About of SSMS)?






On 6/30/08 1:44 PM, in article
d84c9913-29bb-403d-b645-257a059dfd62.DeleteThis@z72g2000hsb.googlegroups.com,
"todd.lowney@bankofamerica.com" wrote:

> HI,
>
> I keep getting a "Class Not Registered" error when I try and use the
> Import Export wizard. I've reinstalled several times but I'm still
> having trouble. 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=9.00.1399
> .00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=Unca
> ughtException&LinkId=20476
>
> ===================================
>
> Class not registered
>
> ------------------------------
> Program Location:
>
> at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
> at
> Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs
> 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)
>
 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
Ekrem_Önsoy

External


Since: Aug 29, 2007
Posts: 192



(Msg. 4) Posted: Mon Jun 30, 2008 9:36 pm
Post subject: Re: SQL Server 2005 Management Studio Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hello Todd,

According to my experience, you have not applied SQL Server 2005 Service
Pack 2 to your Client Tools.

You'll probably get rid of this error when you apply the SP2 to your Client
Tools.

--
Ekrem Önsoy



wrote in message

> HI,
>
> I keep getting a "Class Not Registered" error when I try and use the
> Import Export wizard. I've reinstalled several times but I'm still
> having trouble. 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=9....1399.0
>
> ===================================
>
> Class not registered
>
> ------------------------------
> Program Location:
>
> at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
> at
> Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs
> 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)
>
 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
Jeffrey Williams

External


Since: Apr 11, 2008
Posts: 12



(Msg. 5) Posted: Mon Jun 30, 2008 10:10 pm
Post subject: Re: SQL Server 2005 Management Studio Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
todd.lowney DeleteThis @bankofamerica.com wrote:
> On Jun 30, 2:40 pm, "Aaron Bertrand [SQL Server MVP]"
> wrote:
>> How exactly are you launching the wizard? Are you doing so against a local
>> or a remote instance? Using what authentication method? What version is
>> the server where you are launching the wizard (you can see this in its top
>> node in Object Explorer)? What is the version of your client tools (you can
>> see this in Help|About of SSMS)?
>>
>> On 6/30/08 1:44 PM, in article
>> d84c9913-29bb-403d-b645-257a059df... DeleteThis @z72g2000hsb.googlegroups.com,
>>
>>
>>
>> "todd.low...@bankofamerica.com" wrote:
>>> HI,
>>> I keep getting a "Class Not Registered" error when I try and use the
>>> Import Export wizard. I've reinstalled several times but I'm still
>>> having trouble. 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=...
>>> .00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=U­nca
>>> ughtException&LinkId=20476
>>> ===================================
>>> 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)- Hide quoted text -
>> - Show quoted text -
>
>
> I have SP2 on my client tools. The version is 3042. I'm connecting
> to a remote server using Windows Authentication. The server version
> is 3239. I get the error for when I right click on a [database name]-
>> Tasks->Import Data or Export Data. I'm wondering if there is a
> registry issue with my client tools install.
>

Hmmm, that means you have a lower version of the client tools accessing
a higher version on the database. Generally, I have seen this cause
multiple problems.

Any chance you could upgrade your client tools to the same version that
you are connecting to? By the version number, I am guessing either CU6
or CU7.
 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
Todd

External


Since: Jul 07, 2008
Posts: 2



(Msg. 6) Posted: Mon Jul 07, 2008 7:02 am
Post subject: Re: SQL Server 2005 Management Studio Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I tried upgrading my client tools, but I still get the same error. I
did try to create a new SSIS package in BIDS and got a "Class Not
Registered" error message when I try to create a new OLEDB connection
manager. It did not have any technical details with the error. I've
tried reinstalling Mgmt Studio several times, and I've also tried
removing SSIS and installing it again. I get the same error each
time. Any more ideas ??? Thanks to all for trying!!
 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
Todd

External


Since: Jul 07, 2008
Posts: 2



(Msg. 7) Posted: Wed Jul 09, 2008 10:21 am
Post subject: Re: SQL Server 2005 Management Studio Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I resolved the problem Smile A co-worker suggested that I run the MDAC
Component Checker tool, which showed that I was missing the
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...43-bf53
 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
Ekrem_Önsoy

External


Since: Aug 29, 2007
Posts: 192



(Msg. 8) Posted: Wed Jul 09, 2008 8:56 pm
Post subject: Re: SQL Server 2005 Management Studio Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks for the feedback, I'll document it in my web site.

--
Ekrem Önsoy



"Todd" wrote in message

>I resolved the problem Smile A co-worker suggested that I run the MDAC
> Component Checker tool, which showed that I was missing the
> 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...43-bf53
>
 >> Stay informed about: SQL Server 2005 Management Studio Error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL Server Management Studio Express error - When trying to open tables in remote SQL 2000 database I get error InvalidArument=Value of '6' is not valid for 'index' Parameter name:index The database is up and running so it's not a problem with the table itself. Any suggestions on how to resolve...

SQL Server 2005 Management studio used with SQL 2000 datab.. -

SQL Server Management Studio - Is it possible to delete a group of stored procedure in one action, as it was using the mmc in SQL2000 ? Or do I have to delete each store proc one at a time ???

where is SQL Server Management Studio? - Hi, I've installed SQL Server 2005 Dev and VS 2005 pro. I just can't find SQL Server Management Studio from the menu start-> programs-> SQL Server 2005. Can you help me? Thank you.

Alternative to SQL Server Management Studio? - Does anyone have any suggestions for 3rd party tools to replace SQL Server Management Studio. SMS is such bloatware and lacks so many nice features of Enterprise Manager that there must be some decent tools out there to use instead. I know there's..
   Database Forums (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]