?
Solved

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

Posted on 2006-06-30
4
Medium Priority
?
408 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
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.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

752 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