Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
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,…
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 …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

773 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