Install of SP1 for SQL 2008 hangs at initial rules check

  • 64-bit laptop with 4GB RAM, Windows 2008 R2 Standard, Hyper-V R2, VM with Windows 2008 R2 Standard with 1024 MB memory allocated and 3 x 20 GB drives, SQL 2008 Standard.

    I successfuly installed SQL 2008 on the VM, noting the warning at the outset of the install that SP1 must be installed before SQL can be run.

    I have tried several times to install SP1 - but it always hangs at the first rule check. It can only be interrupted in Task Manager.

    I have downloaded a fresh copy of SP1 and tried - same outcome.

    I am unable to find a similar report in Google.

    Help!

    Tim T.

  • Have you tried running it from the command prompt, google has a few links on how to do this.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • Well...my first honest response was "What difference will that make?" but I'm the newbie here, so I tried it.

    I haven't tried to manually extract the contents of the SP1 .EXE to find the core SETUP.EXE so I used that very long .EXE name rather like this:

    thatverylong.exe /ACTION=Upgrade /INSTANCENAME="Instance" /INSTANCEID=MSSQLSERVER" /ISSVCACCOUNT="NT Authority\NetworkService"

    This whistled through the opening rule but eventually stopped with:

    "SQL Server Setup has encountered the following error:

    The specified action Upgrade is not supported for the SQL Server patching operation.

    Error code 0x84BF0007"

    So - further than before but still not sucessful.

    Right now, courtesy of a snapshot in Hyper-V, I am going back to install SQL 2008 and the Books Online so that I may investigate further...

    Thanks for your help so far!

    Tim T.

  • Try the MS link below...

  • Stand down...

    With SQL 2008 reinstalled, this time with BOL, I ran the SP1 .EXE ... and it ran through to completion.

    Tada!

    Personally, I hate problems which "go away" because I can't say what caused them or say that they won't recur. For now, however, I have a SP1'ed SQL 2008 server for my VM farm. Whoopee!

    Tim T.

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

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