# Saturday, June 17, 2006
« Customer Day Presentation | Main | Analysis Services Resources »

It seems a number of people are having problems installing this service pack. There are a couple of solutions (here, here and here) that may work. There is also anecdotal evidence that exctacting the files from the SP executable using WinRAR andf running HotFix.exe manually may work.

Alternatively, I have found that the following works for me:

  1. Download the service pack and start the installation by double-clicking the downloaded executable.
  2. Once product enumeration is complete click Next at the Welcome page.
  3. At the End User License Agreement page, check the box to accept the terms and conditions before clicking Next.
  4. Select All Instances, Windows Authentication at the Authentication Mode page and click Next.
  5. Click Install to begin the installation.
  6. During the install you will be told about pending file operations. Click Yes.
    Pendingfileops
  7. A further message appears complaining about processes locking files. At this point, stop the SQL Server Full Text Search service and click Try Again. You may also need to click Try Again additional times depending on what SQL Server processes happen to be running.
    Lockedfiles
by This posting is provided "AS IS" with no warranties, and confers no rights.
posted on Saturday, June 17, 2006 12:01:48 PM (GMT Daylight Time, UTC+01:00)  #    Comments [0] Trackback
Related posts:
Do you have great business intelligence skills?
Integration Services Design Principals
Physical Data Warehouse Design
Analysis Services Essential Reading
When should you do an incremental extract?
Post TechReady and Popfly Invites
Comments are closed.