Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

WSUS:  SQL service pack four not showing up in admin console

Posted on 2006-06-30
4
Medium Priority
?
423 Views
Last Modified: 2008-02-01
Hi,
I finally broke down and installed WSUS last week. It's handling about 200 PCs and working pretty well.
Except in the WSUS console it's not offering me any SQL Service Packs to approve.
When I search all updates and filter on the string "SQL" the view it returns shows just 4 entries...

Critical Update for SQL Server 2000 Desktop Engine (Windows)r... Critical Updates      4/26/2005      Mixed
Cumulative Patch for SQL Server 2000 Desktop Engine (Windows)      Security Updates      11/13/2003      Mixed
Windows Server Update Services Service Pack 1      Service Packs      6/27/2006      Mixed
Update for SQL Server 2000 Desktop Engine (SharePoint) on Windows...      Updates      11/29/2005      Mixed

...and three of them it says are superseded by other updates. I assume other folks running WSUS see an entry for SQL SP4 when they do a view on "SQL".

In sycronization options under Products I have All SQL Products selected and I've done several syncs.  Any idea where I'm going wrong?  My goal is to be able to deploy SQL SP4 using WSUS.
0
Comment
Question by:veedar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 85

Expert Comment

by:oBdA
ID: 17018508
Make sure you set the Approval filter to "All Updates" as well; by default, the permissions for service packs are set to "not approved".
In addition, check if Service Packs are selected under Update Classifications in the Options page.
0
 
LVL 15

Author Comment

by:veedar
ID: 17018736
Thanks but I have All Updates, All Updates, Any Time set for my view. And I also have Service Packs selected. Here's what I have under Update Classifications....

Critical Updates
Security Updates
Service Packs
Update Rollups
Updates

 WSUS tells me I have 905 updates and I do see many other service packs in the admin console just not SQL for some reason.
0
 
LVL 15

Author Comment

by:veedar
ID: 17082351
It seems MS has not released any SQL updates through WSUS so what I'm seeing is normal. Can anyone running WSUS confirm this?

http://msmvps.com/blogs/athif/archive/2006/05/17/95432.aspx
0
 
LVL 85

Accepted Solution

by:
oBdA earned 2000 total points
ID: 17083800
What you should see classified as SQL Service Packs on a freshly synchronized WSUS is the SP1 for WSUS (KB919004) (which you have), and SP1 for SQL 2005 (KB913090).
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question