SQL 2005 and SP3

Question

Hello Everyone,

Several months ago I installed SP3 on a SQL 2005 Standard Server and have recently been running into a problem with Windows Update (WU); when I run WU it reports that SP3 needs to be installed.

I ran this query against the computer to determine what the product version was

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Here's the results of the query

9.004035.00  SP3 Standard Edition

So, I'm sure that SP3 is installed why does WU believe differently?

---

Jay Rhoten

Answer 1

Hi

,

Are you sure that WU indicated Sp3 or any other cumulative packages released after sp3 ? I think it might be any other cumulative updates or security updates that was released post sql server 2005 sp3 . I don't think WU will get packages and installs that was installed earlier.

---

Thanks, Leks

Answer 2

When I run WU it reports MSFT SQL Server 2005 under High-Priority Updates......here's the blurb under that.

Security Update for SQL Server 2005 Service Pack 3 (KB970892)

I can download and try to install the update and review the log files for potential issues, but that seems a little extreme.

---

Jay Rhoten

Answer 3

Hey Jay.. This update is not service pack 3, it's a security update for SP3. Microsoft has released a security bulletin last month which says that "they have found a loop hole which could allow attackers to run Remote Code Execution in to your system" to avoid this you need to run this patch against your service pack 3 sql server,  your sql server version will be upgraded to     9.00.4053.00 from     9.00.4035.00

---

Vidhya Sagar. Mark as Answer if it helps!

Answer 4

Thanks for the clarification, I really should have read it more closely.  I downloaded and installed the update/hotfix  and received the following message "A recently applied update, KB970892, failed to install.

I've included some of the relevant bits from all the logs, but the sense I'm getting is either a file missing from the installer cache or a registry key that is set incorrectly.

---------------------------------------------------------------------------------------------

Event Signature
EventType: sqlsesetup
P1:   unknown
P2:   0x663
P3:   unknown
P4:   0x633
P5:   copyengine.cpp@607
P6:   unknown
P7:   sql9
P8:   @
P9:   x86
P10: 4053

---------------------------------------------------------------------------------------------

View the files will be included in the error report
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\HotFix.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970892_sqlrun_sql.msp.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970892_sqlrun_sql.msp.xml

---------------------------------------------------------------------------------------------

Summary
     One or more products failed to install, see above for details
     Exit Code Returned: 1635

---------------------------------------------------------------------------------------------

MSI (s) (54:58) [07:58:37:357]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Looking for sourcelist for product {6C21427B-DF99-44EE-B019-C983DFC15964}
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Adding {6C21427B-DF99-44EE-B019-C983DFC15964}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Now checking product {6C21427B-DF99-44EE-B019-C983DFC15964}
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Media is enabled for product.
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Trying source d:\373cc5c8726b4000b6830749bd51a187\HotFixTools\Files\.
MSI (s) (54:58) [07:58:37:357]: Note: 1: 2203 2: D:\373cc5c8726b4000b6830749bd51a187\HotFixTools\Files\sqlrun_tools.msp 3: -2147287037
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (54:58) [07:58:37:357]: Note: 1: 1706 2: -2147483647 3: sqlrun_tools.msp
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Processing net source list.
MSI (s) (54:58) [07:58:37:357]: Note: 1: 1706 2: -2147483647 3: sqlrun_tools.msp
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Processing media source list.
MSI (s) (54:58) [07:58:38:435]: SOURCEMGMT: Resolved source to: 'sqlrun_tools.msp'
MSI (s) (54:58) [07:58:38:435]: Note: 1: 1314 2: sqlrun_tools.msp
MSI (s) (54:58) [07:58:38:435]: Unable to create a temp copy of patch 'sqlrun_tools.msp'.
MSI (s) (54:58) [07:58:38:435]: Note: 1: 1708
MSI (s) (54:58) [07:58:38:435]: Note: 1: 2729
MSI (s) (54:58) [07:58:38:435]: Note: 1: 2729
MSI (s) (54:58) [07:58:38:435]: Product: Microsoft SQL Server 2005 Tools -- Installation failed.

---------------------------------------------------------------------------------------------

11/05/2009 07:58:19.841 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB970892_sqlrun_tools.msp.log
11/05/2009 07:58:19.841 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
11/05/2009 07:58:19.841 Registry: Read registry key value "Debug", DWORD value = 1
11/05/2009 07:58:19.841 Registry: Set registry key value "Debug", DWORD value = 0
11/05/2009 07:58:38.623 MSP returned 1635: This patch package could not be opened. Verify that the patch package exists and is accessible, or contact the application vendor to verify that this is a valid Windows Installer patch package.
11/05/2009 07:58:38.623 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
11/05/2009 07:58:38.623 Registry: Read registry key value "Debug", DWORD value = 0
11/05/2009 07:58:38.623 Registry: Set registry key value "Debug", DWORD value = 1
11/05/2009 07:58:38.623 Copy Engine: Error, unable to install MSP file: d:\e684facf84111eba4e78b361215ce3\HotFixTools\Files\sqlrun_tools.msp
11/05/2009 07:58:38.623 The following exception occurred: Unable to install Windows Installer MSP file  Date: 11/05/2009 07:58:38.623  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 807
11/05/2009 07:58:39.091 Watson: Param1 = Unknown
11/05/2009 07:58:39.091 Watson: Param2 = 0x663
11/05/2009 07:58:39.091 Watson: Param3 = Unknown
11/05/2009 07:58:39.091 Watson: Param4 = 0x663
11/05/2009 07:58:39.091 Watson: Param5 = copyengine.cpp@807
11/05/2009 07:58:39.091 Watson: Param6 = Unknown
11/05/2009 07:58:39.091 Watson: Param7 = SQLTools9
11/05/2009 07:58:39.091 Watson: Param8 = @
11/05/2009 07:58:39.091 Watson: Param9 = x86
11/05/2009 07:58:39.091 Watson: Param10 = 4053
11/05/2009 07:58:39.091 Installed product: SQLTools9
11/05/2009 07:58:39.091 Hotfix package completed
11/05/2009 07:58:39.091 Attempting to continue the 32 bit ngen queue

---------------------------------------------------------------------------------------------

---

Jay Rhoten

Answer 5

Try removing the existing SQL native client and then start your installation.

---

Thanks, Leks

Answer 6

---------------------------------------------------------------------------------------------

MSI (s) (54:58) [07:58:37:357]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Looking for sourcelist for product {6C21427B-DF99-44EE-B019-C983DFC15964}
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Adding {6C21427B-DF99-44EE-B019-C983DFC15964}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Now checking product {6C21427B-DF99-44EE-B019-C983DFC15964}
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Media is enabled for product.
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Trying source d:\373cc5c8726b4000b6830749bd51a187\HotFixTools\Files\.
MSI (s) (54:58) [07:58:37:357]: Note: 1: 2203 2: D:\373cc5c8726b4000b6830749bd51a187\HotFixTools\Files\sqlrun_tools.msp 3: -2147287037
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (54:58) [07:58:37:357]: Note: 1: 1706 2: -2147483647 3: sqlrun_tools.msp
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Processing net source list.
MSI (s) (54:58) [07:58:37:357]: Note: 1: 1706 2: -2147483647 3: sqlrun_tools.msp
MSI (s) (54:58) [07:58:37:357]: SOURCEMGMT: Processing media source list.
MSI (s) (54:58) [07:58:38:435]: SOURCEMGMT: Resolved source to: 'sqlrun_tools.msp'
MSI (s) (54:58) [07:58:38:435]: Note: 1: 1314 2: sqlrun_tools.msp
MSI (s) (54:58) [07:58:38:435]: Unable to create a temp copy of patch 'sqlrun_tools.msp'.
MSI (s) (54:58) [07:58:38:435]: Note: 1: 1708
MSI (s) (54:58) [07:58:38:435]: Note: 1: 2729
MSI (s) (54:58) [07:58:38:435]: Note: 1: 2729
MSI (s) (54:58) [07:58:38:435]: Product: Microsoft SQL Server 2005 Tools -- Installation failed.

Hi,

From the logs above, the installation cannot find the installation media for the client tools, I think the client tools have not been installed. If you have not installed the client tools, please install it and then try to apply the hotfix/update to see whether it works.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.