Hi, We have try to install an SCCM 2012 R2 over one server, in another server we installed SQL server 2012 SP2. 

The server with SQL Server has the Collation parameter set to SQL_Latin1_General_CP1_CI_AS, both servers are using English US as their locale language.

When we are installing and when the installer are creating the DB and views on the another server we receive a fatal error. Reviewing the installation log we find the following error "LCID 22538 is not supported by SQL Server"

The LCID 22538 are Spanish Latinamerica, but both servers are using in their OS settings English US.

We need to install the SCCM 2012 R2 for this clien

The installation log has the following records:

error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 22538 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~. Configuration Manager Setup 7/9/2015 5:20:43 p. m. 2212 (0x08A4)
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14 Configuration Manager Setup 7/9/2015 5:20:43 p. m. 2212 (0x08A4)
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem Configuration Manager Setup 7/9/2015 5:20:43 p. m. 2212 (0x08A4)
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem) Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 22538 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~. Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14 Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem) Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 22538 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~. Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14 Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem) Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 22538 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~. Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14 Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem) Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 22538 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~. Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14 Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem) Configuration Manager Setup 7/9/2015 5:20:44 p. m. 2212 (0x08A4)

Why are you installing the SQL to another server in the first place? How many clients do you have to manage? It's best practice to collocate SQL with ConfigMgr itself, if this is a small scale (under 100k clients) deployment.

check the Regional Settings, for System Locale (non-Unicode) - are you sure this is set to be en-US ?

Yes I'm pretty sure.

Dear buddy , Narcoticoo, we are installing in another server for licensing ($$$$$) themes, because we have to install many servers of the suite of System Center and we dont have sufficient licenses for all them.

And We dont want to use SQL Ex

I realise this is not actually answering your question about the install error. The SQL license is included as part of the System Center 2012 license:

Licensing Overview
System Center 2012 R2 is licensed by:
License required only for endpoints being managed. No additional licenses are needed for management servers or SQL Server technology.

Reference here: http://download.microsoft.com/download/B/4/A/B4A98A4E-2F43-489D-8761-5362C8C2C328/System_Center_2012_R2_Licensing_Datasheet.pdf

Can you confirm the culture setting on both servers? PowerShell is simple enough..

PS > Get-Culture

LCID             Name             DisplayName                                                                                              
----             ----             -----------                                                                                              
1033             en-US            English (United States) 

Licensing isn't an issue, because the license for SQL is included in the System Center license as NolanC already explained. ConfigMgr should co-locate with the SQL like I explained earlier.

The Language in both servers are Englis (US) confirmed using the Get-Culture cmdlet

Seriously, haven't you even considered installing the SQL to the same server as SCCM itself?

Okay, how about the collation of the SQL Server itself? Run this from Management Studio:

select name, collation_name from sys.databases

This is what I got from my test server

name    collation_name
master    SQL_Latin1_General_CP1_CI_AS
tempdb    SQL_Latin1_General_CP1_CI_AS
model    SQL_Latin1_General_CP1_CI_AS
msdb    SQL_Latin1_General_CP1_CI_AS
CM_PRI SQL_Latin1_General_CP1_CI_AS

Nothing in what you provided suggests the wrong SQL version, however can you also confirm you are running 64 bit SQL? Enter this again in Management Studio

select @@version

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
    Oct 19 2012 13:38:57
    Copyright (c) Microsoft Corporation
    Business Intelligence Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

If your SQL Server is not in use by another application do you have the option of wiping it and starting again?

And don't forget to check your WSUS's server SQL instance too.

We solved the problem reinstalling using SQL server 2012 SP1 provided with SCCM 2012 R2 on the same hardware where we have the previous SQL Server 2012 SP2.

We just uninstall the SQL Server 2012 SP2, and the reinstall using the SW provided for SCCM 2012 R2 and all works fine.