Solved

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

Posted on 2006-06-30
4
383 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
  • 2
  • 2
4 Comments
 
LVL 83

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 83

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

by Batuhan Cetin In this article I will be guiding through the process of removing a failed DC metadata from Active Directory (hereafter, AD) using the ntdsutil tool in a Windows Server 2003 environment. These steps are not necessary in a Win…
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

912 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now