We help IT Professionals succeed at work.

Sql Server 2005 SP2 Client Tools Install Failure

Medium Priority
5,718 Views
Last Modified: 2008-09-25
I ran through the sp2 install on my W2K3 SQL 2K5 Server and all completed successfully except the Client Tools. What are the ramifications of thes porblem? Here is the error portion of the log:

Property(S): TOOLS200564Hotfix3042 = f:\b9bed64c5a0167250927\HotFixTools\Files\sqlrun_tools.msp
MSI (s) (D8:2C) [22:01:16:453]: Product: Microsoft SQL Server 2005 Tools (64-bit) - Update 'Service Pack 2 for SQL Server Tools and Workstation Components 2005 (64-bit) ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log.

MSI (s) (D8:2C) [22:01:16:453]: Note: 1: 1729
MSI (s) (D8:2C) [22:01:16:453]: Transforming table Error.

MSI (s) (D8:2C) [22:01:16:468]: Transforming table Error.

MSI (s) (D8:2C) [22:01:16:468]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D8:2C) [22:01:16:468]: Transforming table Error.

MSI (s) (D8:2C) [22:01:16:484]: Transforming table Error.

MSI (s) (D8:2C) [22:01:16:484]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D8:2C) [22:01:16:484]: Product: Microsoft SQL Server 2005 Tools (64-bit) -- Configuration failed.

MSI (s) (D8:2C) [22:01:16:484]: Attempting to delete file C:\WINDOWS\Installer\12a1b3.msp
MSI (s) (D8:2C) [22:01:16:484]: Unable to delete the file. LastError = 32
MSI (s) (D8:2C) [22:01:16:609]: Cleaning up uninstalled install packages, if any exist
MSI (s) (D8:2C) [22:01:16:625]: MainEngineThread is returning 1603
MSI (s) (D8:44) [22:01:16:625]: Destroying RemoteAPI object.
MSI (s) (D8:B8) [22:01:16:625]: Custom Action Manager thread ending.
=== Logging stopped: 1/25/2008  22:01:16 ===
Comment
Watch Question

i would reboot and retry

Author

Commented:
I extracted the files and reran the specific install file called sqlrun_tools.msp

It works fine now.

Commented:
Let's assume for a moment that you still have CD 1 on your drive. Put in CD 2 and run the client install from that.
Although MS includes the option to run the client tools install, you will always get a failure when trying to install the tools as the installation files are on disk 2. With that in mind, run the set up for the tools after you have sucessfully installed the DB.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.