Archive for category WSUS 3.0 SP2 – Sql Express

ERROR 13032 :Microsoft Windows Server Update Services (WSUS) Blocked from Deploying Security Updates

Microsoft Security Advisory (954960)
Microsoft Windows Server Update Services (WSUS) Blocked from Deploying Security
Updateshttp://www.microsoft.com/technet/security/advisory/954960.mspx
———————————
Windowsupdate.log:
WARNING: WU client failed Searching for update with error 0x8024400e
PT WARNING: SyncUpdates_WithRecovery failed.: 0x8024400e
PT WARNING: Sync of Updates: 0x8024400e
PT WARNING: SyncServerUpdatesInternal failed: 0x8024400e
WARNING: Failed to synchronize, error = 0x8024400E
WARNING: Exit code = 0x8024400E

 

—————————————–

RESOLUTION:
In order to reset the approvals to a consistent state on the WSUS server, follow these steps from the WSUS Administration Console
1. Find the ‘Office 2003 Service Pack 1’ update in the updates list. This may involve changing the Approval and   Status filters in the update UI (set the Status to “Any” and the Approval to “Declined” – if you don’t see it then set the Approval to “Any except Declined”
2. Perform the following steps:
    a. First make sure the update is declined.
         i. If the update is not yet declined, right click on the update and decline it.
   b. Next, approve the update.
         i. Right click on the update and select the ‘Approve…’ option in the context menu.
        ii. In the ‘Approve Updates’ dialog that opens, just click ‘OK’. Dismiss the ‘Approval Progress’ dialog that appears.
   c. Next, decline the update.
         i. Right click on the update and select the ‘Approve…’ option in the context menu.
        ii. In the ‘Approve Updates’ dialog that opens, just click ‘OK’. Dismiss the ‘Approval Progress’ dialog that   appears.The computers that were failing detection will now successfully complete detection against the server and receive any applicable updates

Tags: ,

SQLSERVERAGENT Error:103

WSUS 3.0 SP2 and SQL Express installed locally.
You receive the following error in Application Log:
SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but ‘(Unknown)’ is not a member of the SysAdmin role).
 

Open Sql Express and roght click on SUSDB database, select New Query 

On the right side paste the following code and click Execute

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
GO

Then 

RECONFIGURE
GO
  

and click Execute

Tags: