Monday, December 21, 2015

SQL Server security mode Warning and SQL Server process memory allocation Warning - SCCM 2012 R2 - Resolved

I received 2 SQL server related warning while installing SCCM. one of the warning is SQL Server security mode warning - The SQL Server name specified is configured for SQL authentication security. It is recommended to configure the SQL Server to operate only in Windows authentication security before you continue Configuration Manager Setup. 
To resolve this warning you will have to change SQL server configuration.
On the SQL Server, Right click SQL instance go to properties and then Security. Make sure you have selected Windows Authentication Mode only, and run check to verify warning is gone.
And the second Warning is SQL Server process memory allocation - Configuration Manager requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory for the central administration site and primary site and a minimum of 4 gigabytes (GB) for the secondary site. This memory is reserved by using the Minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studio. For more information about how to set a fixed amount of memory, see http://go.microsoft.com/fwlink/p/?LinkId=233759.

Other Errors Resolved
Resolved SCCM (extadsh) Schema Extension Error code 8224 and 8202
Resolved SCCM 2012 R2 - BITs Installed/Enabled Warning & Microsoft Remote Differential Compression (RDC) library failed
SQL Server security mode Warning and SQL Server process memory allocation Warning - SCCM 2012 R2 - Resolved 
SCCM 2012 R2 Prerequisite failed (USMT, Deployment Tools, Windows PE) resolved
Resolved SCCM 2012 R2 - Site server computer account administrative rights failed 

WSUS on Site Server - Warning SCCM 2012 r2 prerequisite resolved

On Same properties of sql server, under Memory set minimum and maximum memory to 8192. and warning will go away.
I am clearing warnings and errors one by one, next article I will be resolving WSUS on site Server Warning.

No comments: