Install of SP1 for SQL 2008 hangs at initial rules check

• tim 45570

  SSC Veteran

  Points: 233

  More actions

  March 26, 2010 at 3:25 am

  #219824

  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.

• Carolyn Richardson

  SSCrazy Eights

  Points: 8357

  More actions

  March 26, 2010 at 4:20 am

  #1140238

  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]

• tim 45570

  SSC Veteran

  Points: 233

  More actions

  March 26, 2010 at 8:58 am

  #1140424

  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.

• sql_lock

  SSCrazy Eights

  Points: 9375

  More actions

  March 26, 2010 at 9:05 am

  #1140433

  Try the MS link below...

• tim 45570

  SSC Veteran

  Points: 233

  More actions

  March 26, 2010 at 9:49 am

  #1140468

  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.