 |
 |
Unable to connect to WSUS WID with SQL Management Studio V20, does not support encryption We just had a customer where a newer version of SQL Server Management Studio was installed to manage the WID (Windows Internal Database) of the WSUS server on a Server 2022 OS. With the EOL for WSUS Server (only […]
Windows Update Server crashed often on Server 2016/2022 with WID Windows Internal Database. We have seen several newer WSUS Servers crahsing or hanging more often with SRV 2016 and even SRV 2019 WSUS. The source may be this table, which is 26GB and holds all the patch information and language descriptions. The full WID DB […]
Mcafee/Trellix EPO 5.10 SP1 Update 2, LDAP Sync Save Agent Settings FAILS/Stalls Bug Do not add, change, or modify Organizational Units (OUs) in Active Directory where you sync via LDAP. You won’t be able to change the LDAP Sync settings in EPO 5.10 SP1 UPD. We have just wasted a full morning on a bug […]
Had a case where the McAfee EPO DB almost blew due to an EPO issue or, let’s say, McAfee prevented it from happening by encountering SQL-Express limitations. We’re relieved that since EPO 5.X, they’ve implemented two databases; one for EPO and one for Events; effectively splitting the load in size and safeguarding the crucial elements. […]
For all DBA’s > Yes we know but Mcafee tells us to shrink 😉 Also see our security concerning regarding centralizes SQL for Security Appliances/Servers. Problem: You are unable to shrink the Mcafee EPO SQL Database with Management Studio (GUI). You are already on “SIMPLE RECOVERY” mode for the DB. Management […]
THIS KB is valid for EPO4/5 until 5.1 and even with the SPLIT in TWO database this still happens in 2024. We just had a case where the OrionAuditlog table was 22GB+ on the MAIN DB. Sample Problem: VMWARE Monitoring Events from “Vmware Converter and Tools” fill the EPO Database rapidly (1GB/Hour). delete from EPOEvents […]
Event ID 7053,12072,12052,12042,12012,13042 on WSUS Server ERROR: Unable to open WSUS MMC or connect with Script/PS/Tools to the WSUS database. On Clients or Server your see an error when this happens because the WSUS APP Pool on IIS is down. Whats the problem? If this happens you will after a reboot of the server […]
Database Configuration: Ensure the following settings for the EPO Database: Autoshrink: False Auto Close: False Auto Update Statistics: True These settings prevent unnecessary shrinking and closing of the database, while maintaining up-to-date statistics for efficient performance. Customization for Rare Circumstances: While Auto Update Statistics is generally recommended as true, there might […]
McAfee EPO Server SQL Server Performance tips This is based on McAfee Information for their McAfee EPO DB running under SQL 2005/2008R2/2012 upwards The EPO Database itself should be: Autoshrink = False Auto Close = False Auto update Statistics = True Auto shrink and auto close are database options that should be set to false. […]
Not only ET wants to phone home! Microsoft is bombing even corporate customers and small business customers with Updates they don’t want and never agreed. KB3022345 seems to be a patch for Clients and servers which send a lot of Information encoded over SSL to Microsoft Servers. They must be in short time for their […]
We mainly have seen this on Small Business Servers SBS. We migrated WSUS to a standalone Server and wanted to remove the SBS integrated WSUS Server. Problem 1: WSUS Database lock prevents handling of SQL DB from Windows Update Server. Error: ALTER DATABASE failed because a lock could not be placed on database ‘SUSDB’. […]
Connect to SQL Internal WSUS Datbase on diffrrent OS: Auf 2003: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\queryAuf 2012R2: \\.\pipe\microsoft##WID\tsql\query Missing “SelfUpdate” in Default Website when running WSUS under 8530 To make sure that the self-update tree is working correctly, first make sure that there is a Web site set up on port 80 of the WSUS server. You must have […]
Here are two ways to see which database is using a lot of memory on your SQL. Keep in mind that the task manager is only showing max. 4GB of memory even if you have like 8GB running. SELECT (CASE WHEN ([is_modified] = 1) THEN ‘Dirty’ ELSE ‘Clean’ END) AS ‘Page State’, (CASE WHEN ([database_id] […]
OSQL.exe Standalone http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15748 How to shrink WSUS 3.X Database with Express Edition http://gallery.technet.microsoft.com/scriptcenter/6f8cde49-5c52-4abd-9820-f1d270ddea61 sqlcmd –I -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query –i <scriptLocation>\WsusDBMaintenance.sql use the WsusDBMaintenance.sql script from the MS Link.
Mcafee Framework 4.6 is out Please check the 4 important Hotfixes which may seem important if you have “MS Malicious Software Removal Tool” installed. https://kc.mcafee.com/corporate/index?page=content&id=KB72202 1 Install/deploy Framework 4.62 Install HF660014 3 Install HF660568 Migration from Server 2003R2 32BIt to Windows Server R2008 R2 64bit (Same Server Name a must) Mcafee KB66616 (OS=OS) und KB71078 (OS !=OS). Sollte […]