Sql Server 2005 SP2 Client Tools Install Failure

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 ===
advlgxAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
maxis2cuteConnect With a Mentor Commented:
i would reboot and retry
0
 
advlgxAuthor Commented:
I extracted the files and reran the specific install file called sqlrun_tools.msp

It works fine now.
0
 
lahaleCommented:
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.
0
All Courses

From novice to tech pro — start learning today.