This may not be an issue right now, but unless your SQL Express is at least 2008 R2, the limit is 4 GB (it was increased to 10 GB with 2008 R2). Depending on the OS and SQL version, you may have to think about migrating to the Windows Internal DB, which I think is the recommendation for WSUS due to the limits of the Express DB.
-----Original Message----- From: listsadmin@lists.myitforum.com [mailto:listsadmin@lists.myitforum.com] On Behalf Of Michael Leone Sent: Monday, September 21, 2015 10:15 AM To: ntsys...@lists.myitforum.com; WSUS Mailing List <w...@listserv.patchmanagement.org> Subject: [NTSysADM] 1 client not showing up in WSUS 3.0 SP2 I have a Win2012 R2 client, and it is set to look at my WSUS 3.0 SP2 server. It is assigned by GPO, and it is getting the right GPO, and the proper settings are being applied. Yet, this one client does not show up in the WSUS console at all. (WSUS 3.2.7600.226) The client knows it's supposed to talk to my server; I did a /resetauthorization and /detectnow, and the client log seems to indicate that everything is applied correctly. 2015-09-21 09:52:21:985 744 8bc Misc =========== Logging initialized (build: 7.9.9600.18039, tz: -0400) =========== 2015-09-21 09:52:21:985 744 8bc Misc = Process: C:\Windows\system32\svchost.exe 2015-09-21 09:52:21:985 744 8bc Misc = Module: c:\windows\system32\wuaueng.dll 2015-09-21 09:52:21:985 744 8bc Service ************* 2015-09-21 09:52:21:985 744 8bc Service ** START ** Service: Service startup 2015-09-21 09:52:21:985 744 8bc Service ********* 2015-09-21 09:52:21:985 744 8bc IdleTmr Non-AoAc machine. Aoac operations will be ignored. 2015-09-21 09:52:21:985 744 8bc Agent * WU client version 7.9.9600.18039 2015-09-21 09:52:21:985 744 8bc Agent WARNING: SleepStudyTracker: Machine is non-AOAC. Sleep study tracker disabled. 2015-09-21 09:52:21:985 744 8bc Agent * Base directory: C:\Windows\SoftwareDistribution 2015-09-21 09:52:21:985 744 8bc Agent * Access type: No proxy 2015-09-21 09:52:21:985 744 8bc Service UpdateNetworkState Ipv6, cNetworkInterfaces = 0. 2015-09-21 09:52:21:985 744 8bc Service UpdateNetworkState Ipv4, cNetworkInterfaces = 1. 2015-09-21 09:52:21:985 744 8bc Agent * Network state: Connected 2015-09-21 09:52:22:000 744 8bc Service UpdateNetworkState Ipv6, cNetworkInterfaces = 0. 2015-09-21 09:52:22:000 744 8bc Service UpdateNetworkState Ipv4, cNetworkInterfaces = 1. 2015-09-21 09:52:22:031 744 8bc Agent *********** Agent: Initializing global settings cache *********** 2015-09-21 09:52:22:031 744 8bc Agent * Endpoint Provider: 00000000-0000-0000-0000-000000000000 2015-09-21 09:52:22:031 744 8bc Agent * WSUS server: http://dctrman001.wrk.ads.pha.phila.gov 2015-09-21 09:52:22:031 744 8bc Agent * WSUS status server: http://dctrman001.wrk.ads.pha.phila.gov 2015-09-21 09:52:22:031 744 8bc Agent * Target group: (Unassigned Computers) 2015-09-21 09:52:22:031 744 8bc Agent * Windows Update access disabled: No 2015-09-21 09:52:22:047 744 8bc AU # Policy Driven Provider: http://dctrman001.wrk.ads.pha.phila.gov 2015-09-21 09:52:22:047 744 8bc AU # Detection frequency: 22 2015-09-21 09:52:22:047 744 8bc AU # Approval type: Pre-download notify (Policy) And yet the WSUS console shows no such machine ... Yes, I have refreshed multiple times, and have waited 45 minutes or so for it to show up. There isn't a limit on number of clients, right? I have 162, running on a locally installed SQL Express DB that is 3.5G in size, at the moment.
