Post reply

Unable to upgrade from 10.2.4000 to 2008 R2 emergency

  • November 13, 2011 at 4:09 am

    #390849

    Hello all

    I have a huge emergency in my hands

    I really need to upgrade two instances of sql server to 2008 R2 in a couple hours the server says it is on 10.2.4000, when I try to run the installer is says that it can't upgrade because I am not selecting anything, but I do not have any option to select, is there any way to force the installation? what can I do?

    Thanks in advance

  • November 13, 2011 at 4:31 am

    #1406803

    Huh???

    When run the installer, are you selecting at least one database engine on the installation selection screen?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 13, 2011 at 4:39 am

    #1406805

    Yes i select the instance I want to upgrade

    since nothing worked I tried this:

    Setup.exe /q /ACTION=upgrade /INSTANCENAME=MSSQLSERVER /RSUPGRADEDATABASEACCOUNT="superuser" /RSUPGRADEPASSWORD="password" /ISSVCAccount="NT Authority\Network Service" /IACCEPTSQLSERVERLICENSETERMS

    it worked on one instance but when I tried the other the process finished and the instance is no more on the Sql server configuration manager, it is really weird since it is on services,msc, but I can't start the service, right now this is a major issue, I really need some help

  • November 13, 2011 at 4:51 am

    #1406807

    If it's an urgent, major, critical issue, I suggest you open a case with Microsoft CSS.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 13, 2011 at 4:56 am

    #1406809

    Thanks

    I will try to install all over again

  • November 14, 2011 at 7:02 am

    #1407133

    GilaMonster (11/13/2011)

    If it's an urgent, major, critical issue, I suggest you open a case with Microsoft CSS.

    Very STRONG agreement here Gail! Anything that is marked as "huge emergency" OR "needs to happen in a couple of hours" simply does NOT belong on a forum post.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • November 14, 2011 at 7:20 am

    #1407142

    TheSQLGuru (11/14/2011)

    GilaMonster (11/13/2011)

    If it's an urgent, major, critical issue, I suggest you open a case with Microsoft CSS.

    Very STRONG agreement here Gail! Anything that is marked as "huge emergency" OR "needs to happen in a couple of hours" simply does NOT belong on a forum post.

    Especially not on a Sunday afternoon.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 14, 2011 at 8:11 am

    #1407188

    well my experience with MS support is that they won't fix any of my isues or are even more lost than myself,

    The solution was "easy" I changed a couple registry entries since that instance was corrupt and didn't allow me to uninstall it, create a backup of master, msdb and such, install again and replace the system databases with the backup, everything was up in half an hour

    Thanks to all

  • November 15, 2011 at 3:10 am

    #1407695

    I changed a couple registry

    It worked for you but it’s not recommended (could be very risky). In worst scenario it could lead you to system crash as well.

  • November 15, 2011 at 7:22 am

    #1407868

    Dev (11/15/2011)

    I changed a couple registry

    It worked for you but it’s not recommended (could be very risky). In worst scenario it could lead you to system crash as well.

    Of course you shouldn't touch the registry unless you know what you are doing

    If any have this kind of problem the ting is that the installer for some reason disable the instance, there is a key for that in the registry, you won't be able to uninstall it unless you change that

  • November 15, 2011 at 10:53 am

    #1408073

    ricardo_chicas (11/15/2011)

    Dev (11/15/2011)

    I changed a couple registry

    It worked for you but it’s not recommended (could be very risky). In worst scenario it could lead you to system crash as well.

    Of course you shouldn't touch the registry unless you know what you are doing

    If any have this kind of problem the ting is that the installer for some reason disable the instance, there is a key for that in the registry, you won't be able to uninstall it unless you change that

    Just a word of Caution (if somebody think to mimic you) 😀

Viewing 11 posts - 1 through 10 (of 10 total)

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