Solved

SQL 2005 SP4 Error

Posted on 2015-02-18
20
423 Views
Last Modified: 2016-02-25
Dear EE,

I am trying to install SP4 on SQL 2005 in production and it gives me following error.

Please see attached file for error.

I will be grateful to you if you please help me in this regard.

Thanks
SQL-SP-error.jpg
0
Comment
Question by:Netsol-NOS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 9
20 Comments
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40616189
Check the installation logs and in the event logs for any error during the process.
0
 

Author Comment

by:Netsol-NOS
ID: 40616193
Dear Vitor,

Hope you are fine. Its good to see you again..:)
thank you for your reply.

let me send you the logs.

Thanks
0
 

Author Comment

by:Netsol-NOS
ID: 40616225
Dear Vitor,

Please join GTM
1.  Please join my meeting.
https://global.gotomeeting.com/join/209793509

Meeting ID: 209-793-509

Password = 123456

Thanks
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Author Comment

by:Netsol-NOS
ID: 40616238
I can explain you in GTM if it is convenient to you.
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40616249
Sorry, I can't go on meetings now.
Anyway you should post here so if someone in the future has the same issue he or she can find the solution here.
Just post the installation log and event log.
0
 

Author Comment

by:Netsol-NOS
ID: 40616257
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40616283
This entry for summary.txt:
Product Installation Status
Product                   : Setup Support Files
Product Version (Previous): 1399
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_SqlSupport.msi.log
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.


And this one for Hotfix.log:
2/18/2015 16:36:29.749 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_SqlSupport.msi.log
02/18/2015 16:36:29.749 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
02/18/2015 16:36:29.749 Registry: Cannot read registry key value "Debug", error 2
02/18/2015 16:36:34.406 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.

02/18/2015 16:36:34.672 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
02/18/2015 16:36:34.672 Registry: Cannot read registry key value "Debug", error 0
02/18/2015 16:36:34.672 Copy Engine: Error, unable to install MSI file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi
02/18/2015 16:36:34.687 The following exception occurred: Unable to install Windows Installer MSI file  Date: 02/18/2015 16:36:34.687  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 1429


And this one for Redist9_Hotfix_KB955706_SqlSupport.msi.log:
MSI (s) (90:C8) [16:36:34:406]: ¾¾桅䋆¾¾¾¾詬䋆脐䋥¾閡䋆ﶸÑ诜¾弿䋌ﶸÑ诐彣䋌ﶸÑ¾Ā
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.


Shows that you are having permission issues. Are you running the hotfix as an Administrator?
Also check in the EventViewer for errors happened around that time [16:36].
0
 

Author Comment

by:Netsol-NOS
ID: 40616290
I am running all the things with ADMINISTRATOR.

Event Viewer = let me confirm you please wait. thanks.
0
 

Author Comment

by:Netsol-NOS
ID: 40616295
16:36 UNDER APPLICATION:- The description for Event ID ( 11260 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Product: Microsoft SQL Server Setup Support Files (English) -- 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.
, (NULL), (NULL), (NULL), (NULL), , .


THERE IS NO ERROR UNDER SYSTEM ON THAT TIME.
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40616305
Try to right-click of the hotfix file and select the option Run as Administrator.
Also turn off temporary any antivirus product that it's installed in the machine. Do not forget to turn it on immediately after the hotfix finish.
0
 

Author Comment

by:Netsol-NOS
ID: 40616348
i am already login with adminsitrator.

Let me uninstall the Antivirus.
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40616363
No, don't uninstall. Just stop it.
0
 

Author Comment

by:Netsol-NOS
ID: 40618197
It does not work even after uninstall the antivirus.
Problem still there.
0
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40618347
You shouldn't uninstall the AV. Stopping the service would be enough. Hope that you installed back.
Anyway I was making some investigation in this error and found that can be an issue performed by a Windows hotfix. The related hotfix is MS14-049. If you have this hotfix installed you need to uninstall it before installing the SP4.
0
 

Author Comment

by:Netsol-NOS
ID: 40618349
Dear Vitor,

Let me try to unisntall the MS14-049

i will get back to you in 2 hours. As here we have lunch break,

Thanks
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40618350
Here is where I've found the information about the issue.
0
 

Author Comment

by:Netsol-NOS
ID: 40620474
Dear Vitor,

Its little bit amazing that when i install SQL 2005 on machine which was not on DOMAIN the SP 4 successfully installed on that machine.

Thanks
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40620658
The last solution I've provided didn't work?
0
 

Author Closing Comment

by:Netsol-NOS
ID: 40620735
Dear All,

Vitor, has provided excellent solution against my questions. well done Vitor. Thank you so much.

Thanks
NetSol-NOS
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40620743
Thanks. You should reinstall that hotfix since is a security patch. Only problem is that you need to uninstall it every time you need to install an hotfix.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query to summarize items per month 5 84
Help with stripping out character in SQL LEFT/RIGHT/REPLACE 2 52
Help with simplifying SQL 6 54
SSMS Imprt data from Excel 7 37
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question