THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

The Rambling DBA: Jonathan Kehayias

The random ramblings and rantings of frazzled SQL Server DBA

SQL Server 2008 failed installation blocks Service Pack 1 (SP1) installation

While building a Virtual Machine tonight to do some testing and screenshots for a future article/blog post, and possibly for a presentation, I ran into a problem installing SQL Server 2008 on Windows Server 2008.  For whatever reason, during installation the Powershell components for SQL Server 2008 failed to install correctly, but SQL Setup completed successfully and SQL Server was installed and running as expected (at least I never used powershell so it seemed that way).  To be current I went to apply Service Pack 1 (SP1) and the latest Cumulative Updates to my Virtual Machine and I encountered a failed Setup message:

A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

I figured maybe a reboot would solve the problem but no dice.  Not sure what exactly to do in this case I hit the search engines and ran across a couple of posts that didn’t solve the problems.  I tried adding another component, Reporting Services in this case, which didn’t solve the problem, and I was just short of removing SQL Server 2008 and attempting to reinstall fresh when I tried the Repair option under Maintenance.  This fixed the problem and I was able to successfully install Service Pack 1 and the Cumulative Update 4 to the Virtual Machine.

A quick warning here, the Repair option will take the SQL Server Services offline, so if you catch yourself in this scenario, you need to plan for the outage which was about 15 minutes in my case.

Published Friday, September 04, 2009 2:21 AM by Jonathan Kehayias



Brett Anthony said:

Thankyou, saved me lots of time!

October 26, 2009 12:19 AM

F Siregar said:

This article has saved me time too, thank you.

December 11, 2009 8:57 AM

JCHolmes said:

I had the same problem, but the repair failed as well.  Discovered a server admin had started the removal of IIS and logged out without allowing the removal to complete.  I discovered the problem by launching Server Manager and clicking 'Remove Features' in the Feature Summary.  A dialog will tell you if there is a configuration in process that has not completed.

February 10, 2010 11:19 AM

Jim R. said:

Hi all, i tried repair this error without go to repair tool of sql server 2k8, but i failed in the attempt.

My error was set the users for the sql services without Administrator's Permissions in  his Windows's profile.

A recommendation for future instalations: Be sure of the Sql services's user has the rigths permissions.


Jim R.

September 29, 2010 10:46 AM

Richard said:

SQL 2008 R2 repair failed on my dev box with a network error accessing a non-existent x86 file in the x64 directory.

Turns out I needed to uninstall the version of SQLCE which shipped with Visual Studio before the repair would work:

October 25, 2010 2:58 PM
Anonymous comments are disabled

This Blog


Privacy Statement