Netsol-NOS
asked on
SQL 2005 SP4 Error
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
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
Check the installation logs and in the event logs for any error during the process.
ASKER
Dear Vitor,
Hope you are fine. Its good to see you again..:)
thank you for your reply.
let me send you the logs.
Thanks
Hope you are fine. Its good to see you again..:)
thank you for your reply.
let me send you the logs.
Thanks
ASKER
Dear Vitor,
Please join GTM
1. Please join my meeting.
https://global.gotomeeting.com/join/209793509
Meeting ID: 209-793-509
Password = 123456
Thanks
Please join GTM
1. Please join my meeting.
https://global.gotomeeting.com/join/209793509
Meeting ID: 209-793-509
Password = 123456
Thanks
ASKER
I can explain you in GTM if it is convenient to you.
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.
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.
ASKER
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\Redis t9_Hotfix_ KB955706_S qlSupport. 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\Redis t9_Hotfix_ KB955706_S qlSupport. msi.log
02/18/2015 16:36:29.749 Registry: Opened registry key "Software\Policies\Microso ft\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\Microso ft\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\set upmainl1\s etup\sqlse \sqlsedll\ copyengine .cpp Line: 1429
And this one for Redist9_Hotfix_KB955706_Sq lSupport.m si.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].
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\Redis
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\Redis
02/18/2015 16:36:29.749 Registry: Opened registry key "Software\Policies\Microso
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\Microso
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
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\set
And this one for Redist9_Hotfix_KB955706_Sq
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].
ASKER
I am running all the things with ADMINISTRATOR.
Event Viewer = let me confirm you please wait. thanks.
Event Viewer = let me confirm you please wait. thanks.
ASKER
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.
, (NULL), (NULL), (NULL), (NULL), , .
THERE IS NO ERROR UNDER SYSTEM ON THAT TIME.
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.
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.
ASKER
i am already login with adminsitrator.
Let me uninstall the Antivirus.
Let me uninstall the Antivirus.
No, don't uninstall. Just stop it.
ASKER
It does not work even after uninstall the antivirus.
Problem still there.
Problem still there.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Let me try to unisntall the MS14-049
i will get back to you in 2 hours. As here we have lunch break,
Thanks
Here is where I've found the information about the issue.
ASKER
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
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
The last solution I've provided didn't work?
ASKER
Dear All,
Vitor, has provided excellent solution against my questions. well done Vitor. Thank you so much.
Thanks
NetSol-NOS
Vitor, has provided excellent solution against my questions. well done Vitor. Thank you so much.
Thanks
NetSol-NOS
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.