Can not apply SQL server 2008 SP2

  • Hi,

    In one of our server I tried applying SP2 for SQL server 2008. After clicking SP2, it extracts the file but does not start. I checked application and system logs but could not find anything useful. Please advice.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • you can try to check the log file locate in %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\ ?

  • Hope you are not applying sp2 on sql server 2008 R2 edition as it sp2 is not yet released for this version.

  • Hi,

    It is SQL server 2008 with SP1. I checked the logs here in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log. But there is no logs with todays date. Actually once I run the SP2 it extracts the files and disappears. I tried running it from the extracted files. It does not work.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • Your patch file could be corrupted.Check windows event vciwer logs.

  • I checked system log and it has two information log during that time- "The TPM Base Services service entered the stopped state." and "A compatible Trusted Platform Module (TPM) Security Device cannot be found on this computer. TBS could not be started."

    Is this somthing that could be the problem for this?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • redownload installation file: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17

    Try to reboot server and then launch installation again.

  • SP2 is redownloaded and server is restarted but it does not start after extracting the files. Can it be somthing is missing in server?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

Viewing 8 posts - 1 through 7 (of 7 total)

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