[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 897
  • Last Modified:

Upgrade SQL 2005 SP4 just for Workstation Components

I have an application server that only has SQL 2005 Workstation Components installed, no instances.  WSUS says this server needs SQL 2005 SP4, so when I try to install it, the service pack wants to install an instance on my server.  I don't see any selections for Workstation Components only.  Is this a different install or how do I upgrade the Workstation Components without installing a new instance?
0
jpletcher1
Asked:
jpletcher1
1 Solution
 
radcaesarCommented:
Since Its only Client, Its not needed any SP upgrades.
0
 
Daniel_PLDB Expert/ArchitectCommented:
[radcaesar] Since Its only Client, Its not needed any SP upgrades.
That's not true. You can normally update client components also.
Applying SQL Server Service Packs

[jpletcher1] Is this a different install or how do I upgrade the Workstation Components without installing a new instance?
Is this Express edition?
0
 
jpletcher1Author Commented:
This is express edition, yes, and WSUS claims it needs SQL 2005 SP4.  When I go to run the service pack I would think it would recognize the existing parts and ask if I want to upgrade them, but these SQL Express service packs are kind of different I know.  If you  aren't careful you will end up installing another instance instead of upgrading your exisitng instance, or in my case, just the workstation components.
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
Daniel_PLDB Expert/ArchitectCommented:
For Express edition you need to install new SQL Server Management Studio version:
Microsoft SQL Server Management Studio Express Service Pack 4
0
 
jpletcher1Author Commented:
I don't have SQL Studio Management Tools on here.  When I look in add/remove programs, go to SQL Server and choose Change, I get the attached options.. sql
0
 
Daniel_PLDB Expert/ArchitectCommented:
Click on Workstation Components, then on Next. You'll see few new windows (click yes or next). When you get to the screen with choice to change components or remove SQL Server please click on change. You'll be able to see what components you have installed.
0
 
jpletcher1Author Commented:
This is what it shows...

 sql
0
 
ValentinoVBI ConsultantCommented:
Seems good, just keep clicking Next until the wizard starts installing the update.

@radcaesar: every piece of software needs updates...
0
 
Chris MConsulting - Technology ServicesCommented:
Of course if you want to keep working with database servers which have been already upgraded, it's best and RECOMMENDED to update your workstation tools too to the same service pack.

If you run SP4 setup for 2005, it will identify your tools to be updated so you will be able to get them to SP4.

If you do not update your SQL client components/tools then you might have issues with things like viewing & updating/modifying maintenance plans & packages on remote SQL instances which are already upgraded to SP4 while your client tools are not.
0
 
Daniel_PLDB Expert/ArchitectCommented:
As I stated before, you need to install different components of SQL Server because you are using Express edition.
So my advice is to uninstall egsisting client components and install new using SQL Server Express SP4 installer. Choose only client components during installation:
sql expressYou can get one here:
Microsoft SQL Server 2005 Express Edition Service Pack 4

For client components you only need SQLEXPR.EXE or SQLEXPR32.EXE installer. SQLEXPR.EXE contains both 32 and 64 bit versions, SQLEXPR32.EXE contains only 32 bit version.
0
 
jpletcher1Author Commented:
I am still a little leary to uninstall it rather than update in place as there are a ton of applications on this server and I'd hate to break any of them.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now