Sunday, October 26, 2014

MSP Error: 1260 - Applying Service pack on SQL Server 2005.

Error Details

Error Number              : 1260
Error Description         : MSP Error: 1260  Windows cannot open this program because it has been prevented by a software restriction policy. For more information, open Event Viewer or contact your system administrator.

I too found missing file in below path as well.

C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi

1.Go to the Add or Remove Programs section of Control Panel and remove the SQL Server Setup Support Files.

2.Extract service pack file
Ex: SQL Server 2005 SP4 packages to C:\SQLServer2005_SP4\SP4 as follows
SQLServer2005SP4-KB2463332-x86-ENU /x:C:\SQLServer2005_SP4\SP4

3.Install SQL Server Setup Support .msi file of SP4 from extracted path below.
C:\SQLServer2005_SP4\Sp4\hotfixsqlsupport\files.

4.Now apply service pack on SQL Server,It completes successfully.
Posted by at

13 comments:

  1. Rafael RodriguezDecember 29, 2014 at 2:41 PM

    Thanks, it worked :)

    ReplyDelete
  2. UnknownMay 2, 2015 at 11:47 AM

    Thank you, very very very very very very Thank you ^^ Best Post!!

    ReplyDelete
  3. Paul PedrozaMay 5, 2015 at 12:40 PM

    Muchisimas gracias Rajesh,

    Funcionó perfecto para mi en una actualización a SQL Server SP2 donde estaba teniendo el mismo error!!

    ReplyDelete
  4. UnknownMay 20, 2015 at 10:43 PM

    Hi Rajesh, this was very helpful thank you, I got it working after battling for a long time.

    ReplyDelete
  5. UnknownJune 9, 2015 at 9:43 AM

    Loveeeee. It's work.

    ReplyDelete
  6. PaulTinNZJuly 26, 2015 at 4:57 PM

    Thanks Rajesh...saved my bacon.

    ReplyDelete
  7. Frösö 50K ChallengeNovember 12, 2015 at 6:40 AM

    Worked like a charm! :)

    ReplyDelete
  8. twinpilootJanuary 15, 2016 at 6:17 AM

    Thanks. This helped me out as well!

    ReplyDelete
  9. Jorim66September 6, 2016 at 4:55 AM

    Thanks a lot! Helped me installing SP4 for this old stuff (I usually install SQL Server 2012 or 2016...).

    ReplyDelete
  10. UnknownFebruary 2, 2018 at 1:50 PM

    It Works now!! Thanks, this helped me!!

    ReplyDelete
  11. UnknownSeptember 18, 2018 at 2:40 PM

    Thank you

    ReplyDelete
  12. MadhavApril 30, 2019 at 9:25 PM

    Thanks It worked for me

    ReplyDelete
  13. Aurum AeolusJune 8, 2020 at 1:07 AM

    Thank you!

    ReplyDelete

Subscribe to: Post Comments (Atom)