Sage 50 Accounts 2015 (UK) with network share on SBS 2008

What:

Sage 50 Accounts and Small Business Server 2008

Problem:

Customer has Sage data on the network share. He upgraded Sage Accounts software to 2015, which now requires installing Data Service on the SBS 2008. After installing service I still get the following error on the client's PC:
"Unable to connect to the Sage Data Service on machine <hostname>"

Shrink huge WSUS content folder in SBS 2008/2011

What:

Windows Small Business Server 2008/2011

Problem:

C:\WSUS folder grows to large, current size 65GB, it fills up C drive and Exchange stops email flow.

Windows Small Business Server (Windows SBS) Update Services is not running because it automatically turns off if you customize Windows Server Update Services (WSUS)

What:

Windows SBS 2008 or 2011

Problem:

When you go to Windows SBS Console > Security > Updates and click on "Change the software update settings" you get a following message:

Windows Small Business Server (Windows SBS) Update Services is not running because it automatically turns off if you customize Windows Server Update Services (WSUS)...

Exchange 2007, 550 5.7.1 Message rejected as spam by Content Filtering

What:

Small Business Server 2008 with Exchange 2007

Problem:

User is getting bounce back messages when trying to email organization.

Automatically empty "Deleted items" folder, Exchange 2007

What:

Microsoft SBS 2008 with Microsoft Exchange 2007

Problem:

Users are keeping hundreds of emails in Deleted Items folder.

SBS 2008 sqlservr.exe - MSSQL$MICROSOFT##SSEE high memory usage

What:

Microsoft SQL Server on Windows Small Business Server 2008

Problem:

Microsoft SQL Server is using huge amount of memory, makes server slow and unresponsive.

SBS 2008 sqlservr.exe SBSMONITORING - high memory usage

What:

Microsoft SQL Server on Windows Small Business Server 2008

Problem:

Microsoft SQL Server is using huge amount of memory, makes server slow and unresponsive.

Event ID 10016 logged on Windows SBS 2008

What:

Microsoft Windows Small Business Server 2008

Problem:

Event ID 10016 from DistributedCOM

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1} to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

Self issued security certificate has expired, Windows SBS 2008

What:

Windows Small Business Server 2008

Problem:

Logged Warning Event ID: 64, certificate is about to expire.
Finally users are getting Security Alert pop-up in Outlook:
"The security certificate has expired or is not yet valid"