SQL Server 2008 upgradation failed

  • Hello there,

    I encountered an issue while upgrading SQL SERVER 2008.

    Below mentioned are the steps i followed during the process:

    1). Installed SQL Server 2005

    2). Installed SQL Server 2005 SP2

    3). Installed SQL Server 2005 SP3

    4). while upgrading to SQL Server 2008,it says "Your SQL Server installation is either corrupt or has been tampered with(SQL Registry Version Not Same as Server). Please uninstall the setup to correct this problem" and Database services fails.

    Can someone help me with this issue?.

    Thanks,

    Kiran

  • Are you able to logon to the SQL Server 2005 installation? Also the error logs located at the SetupBootstrap folder gives more information on the reason for the failure.

    On a different note, you can install Service Pack3 directly without having to install SP1, SP2 etc.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • I was able to log in to sql 2005. But when i try to upgrade to sql 2008 it fails.

  • Why are you installing SQL 2005 before you install SQL 2008? Are you trying to simulate an upgrade you are planning for a live server?

    It is far safer to migrate to SQL 2008 by doing a new SQL 2008 install on to a newly built installation of Windows. Doing an upgrade in place works most of the time, but it can fail, so your migration plan needs to include how you would migrate using a newly-built server.

    One issue I have seen is that .Net 3.5 SP1 sometimes fails to install on a box running SQL 2005. There is a tool from Microsoft designed to fix the problem that works in maybe 50% of cases. However, even if it does work it leaves your registry in a state you can not replicate on a newly built box.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • Can you copy paste error from SetupBootstrap Folder.

    It will throw more light on the error part.

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

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