Solved

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

Posted on 2006-06-30
4
400 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 500 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…
Learn about cloud computing and its benefits for small business owners.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

724 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