Post reply

SQL Server upgrade error

  • September 9, 2009 at 9:31 am

    #156196

    Hi,

    I am planing to upgrade sql server 2000 standard edition SP4 to upgrade SQL Server 2005 but when i run upgrade adisor i gets the following error:

    'Cannot use DSO (Decision Support Objects) to connect to Analysis Services, DSO is either not installed ot the installation is corrupted. Error details: Retrieving the COM class factory for component with CLSID {B492C386-0195-11D2-89BA-00C04FB9898D} failed due to the following error: 80040154.'

    ALSO

    if i ignore this error and run installation of sql server upgrade i get the following error:

    upgrade advisor returned -1. error message

    Please help me out,i am fighting with this since last week.

    Thanks

  • September 9, 2009 at 9:55 am

    #1051246

    Did you try Google over the last week??....

    search for this and click on the first link:

    Retrieving the COM class factory for component with CLSID {B492C386-0195-11D2-89BA-00C04FB9898D} failed due to the following error: 80040154

    Your server has analysis services and your 2000 installation is missing a dependency.

  • September 9, 2009 at 10:15 am

    #1051265

    I ran into this issue once."upgrade advisor returned -1" this error is due to missing DLL file.

    Solution for this is Copy BPAClient.dll file from "C:\Program Files\Microsoft SQL Server 2005 Upgrade Advisor\BPA\bin" to "C:\Program Files\Microsoft SQL Server 2005 Upgrade Advisor\BPA"

  • September 9, 2009 at 1:12 pm

    #1051384

    Thank very much sir,now i dont have any error when i run upgrade advisor but when i run sql server setup file for installation/upgrade i get the following error:

    upgrade advisor returned -1. error message

    Any idea please?

    I am also restarting the whole server if it works and let see

    Thanks

  • September 9, 2009 at 1:16 pm

    #1051386

    This is again .dll file issue.

    Copy BPAClient.dll file from "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin" to "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA"

  • September 9, 2009 at 1:21 pm

    #1051394

    Ravi,You cant believe me how stressed i was and i dont have words to say you THANK YOU VERY VERY MUCH.

    It works now.

  • September 9, 2009 at 1:24 pm

    #1051398

    Ravi,Just for information,Do you know why these files were missing or why i need to copy them there?

    I did upgrade in the same server few weeks before and i did,t have any issue but only this first time i was having the problem which you solved for me.

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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