none
Unable to upgrade SQL Server 2008 R2 to SQL Server 2012 SP1

    Question

  • I'm encountering error after error, after successfully installing the upgrade advisor (which took some doing) and running it with essentially no warnings/errors (the one warning was on the connection strings, as I recall -- and all of the warnings had a "fix after" status.

    First failure involved SSRS and the inability to create the "managed account". Backed out the upgrade using http://sqldbanotes.blogspot.com/2013/10/how-to-fix-failed-in-place.html

    Now the failure involves SSAS and unable to connect to analysis services with name MSSQLServerOLAPService.  That is the logical name for the service, although it shows up as just MSSQLServer when looking at it in the services list.  I tried setting the service account to a local account as  well as to Local System -- did not make a difference, the upgrade couldn't apparently find it regardless.

    Has anybody successfully done an in place upgrade from SQL Server 2008 R2 to SQL Server 2012?



    • Edited by Bob Harford Saturday, March 29, 2014 10:14 PM
    Saturday, March 29, 2014 10:05 PM

Answers

All replies

  • Apparently, my last effort was successful.  To get to this point I had to:

    Change SSRS from integrated mode to native mode

    De-install SSAS.

    Saturday, March 29, 2014 10:26 PM
  • Hi Bob,

    Thanks for your post and I am glad to hear that the issue is resolved. Thanks for you posting a reply to share your solution and I had marked it as answer. That way, other community members could benefit from your sharing.

    Regards,
    Sofiya Li

    If you have any feedback on our support, please click here.


    Sofiya Li
    TechNet Community Support


    Monday, March 31, 2014 9:40 AM
    Moderator