We help IT Professionals succeed at work.

Upgrade SQL 2005 SP4 just for Workstation Components

972 Views
Last Modified: 2012-08-14
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?
Comment
Watch Question

Since Its only Client, Its not needed any SP upgrades.
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
[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?

Author

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.
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
For Express edition you need to install new SQL Server Management Studio version:
Microsoft SQL Server Management Studio Express Service Pack 4

Author

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
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
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.

Author

Commented:
This is what it shows...

 sql
ValentinoVBI Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
Seems good, just keep clicking Next until the wizard starts installing the update.

@radcaesar: every piece of software needs updates...
Chris MConsulting - Technology Services
CERTIFIED EXPERT

Commented:
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.
DB Expert/Architect
Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.