Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Problem upgrading SQLServer 2005 client components

Author  Topic 

dhjackal
Starting Member

42 Posts

Posted - 2009-11-11 : 06:58:02
I have inherited several SQL Servers at many different patch levels. I'm trying to upgrade a clustered SQL Server's client components to a standard level (ideally SP CU6 or 8). However whilst trying to upgrade the components on one node i've run into the following ;

SELECT @@verion

Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 1)


SSMS Help About
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.2.3790

When I try and upgrade the client components using the following server pack install ;

SQLServer2005SP2-KB921896-x64-ENU.exe

I get to the section on selecting the components i want to upgrade under the client components i get the following message ;

"Setup cannot update Client Components x86 on this computer. To proceed, run the Service Pack Setup program for the x86 platform instead."

Suggesting that 32bit client components were installed. I did'nt preform the the original install so i'm not sure what was / wasn't installed. Is this possible? and if so is there anything i can do
to resolve the issue and get everything up to SQL Server SP2 9.03042 (or above) on both the server and client side?

Thanks in advance

Declan
   

- Advertisement -