SQL Server Agent (Agent XPs disabled)

How to enable Agent XPs when SQL Agent Service shows "(Agent XPs disabled)".

From SQL Server Management Studio, open query window and use sp_configure commands below:

SP_CONFIGURE 'SHOW ADVANCE',1

GO

RECONFIGURE WITH OVERRIDE

GO

SP_CONFIGURE 'AGENT XPs',1

GO

RECONFIGURE WITH OVERRIDE

GO

Start or restart SQL Agent in SSMS.

Reference:

https://blog.sqlauthority.com/2016/06/13/sql-server-fix-agent-xps-component-turned-off-part-security-configuration-server/

https://blog.sqlauthority.com/2016/02/29/sql-server-unable-to-start-sql-server-agent-failed-to-initialize-sql-agent-log/

RDS and TS CAL Interoperability Matrix

Found this link for good info about CALs and host versions.


https://social.technet.microsoft.com/wiki/contents/articles/14988.rds-and-ts-cal-interoperability-matrix.aspx

Netapp & SMB options

SMB setting changes:

• To enable/disable SMB1
  "cifs control set smb1.enable [yes/no]"
• To enable/disable SMB2
  "options cifs.smb2.enable [on/off]"

Reset SoftwareDistribution Folder

Occassionally, Windows Update process stops cleaning up or something and the C:\WINDOWS\SoftwareDistribution folder starts to get full.


To reset this, stop the service, rename the folder, and restart service.  This should create a new SoftwareDistribution folder:

• Open a CMD window runas admin
• type net stop wuauserv and press enter
• type rename c:\windows\SoftwareDistribution softwaredistribution.oldand press enter
• type net start wuauserv and press enter
• type exit and press enter

Reboot and if all is well, you can delete the old softwaredistribution.old folder.

Large CBS folder in Windows 2008 R2

Possible fix to problem of running out of C: drive space due to log/cab files filling up C:\Windows\Logs\CBS folder...


To reset the compression in the CBS folder use the following method:

1. Disable TrustedInstaller.exe (Windows Module Installer) in Taskmanager Services
2. Delete all the .log files in the C:\Windows\Logs\ CBS directory, delete the .persist and .cab files as well
3. Enable TrustedInstaller.exe again

NOTE: Cleaning up the CBS folder resets the compression process, so the new created log files should not get bigger than 50 Mb before the compression into .cab files as it should be.


Reference:
http://superuser.com/questions/803842/why-is-cbs-log-file-size-20-gb

How to fix WMI

See reference regarding ways to fix problems with WMI.


Reference:
https://katyscode.wordpress.com/2007/02/03/tutorial-how-to-fix-wmi-corruption/

How to change NetworkCategory for Win 2012 R2

By default Win 2012 R2 treats NIC interfaces as PUBLIC.  Even with Windows Firewall OFF, it will still block RDP, etc... from external IPs...  To fix, change NetworkCategory to PRIVATE...

Using GPEDIT.MSC, runas Administrator

• Navigate to Computer Configuration / Windows Settings / Security Settings / Network List Manager Policies.
• Double click the Network name of network that you would like to change the location
• Select the Network Location tab, and set the location to PRIVATE
• Click OK, and close Local Group Policy Editor

Reference:
http://anonit.blogspot.com/2014/02/change-network-location-in-server-2012.html