SCCM 2012 installation Problem "Requires SQL_Latin1_General_CP1_CI_AS"

[TheDai]

Good Morning everyone,

 

I have a problem and thought someone here might be able to help me.

I'm trying to install SCCM 2012 (as a trainee Project) and after a couple of days, it completely broke me.

 

Currently, the last remaining Problem is the following:

 

During the installation check, I get this:

 

Configuration Manager requires that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_AS collation, unless you are using a Chinese operating system and require GB18030 support.

 

1) I'm using SQL Server 2008 SP3 on the machine "hwDB01". However, in the "System" column it displays the name of the SCCM Server ("SCCM"). I don't know why.

 

2) "SQL_Latin1_General_CP1_CI_AS" is (we double checked, reinstalled and double checked again) already configured.

 

I do not understand the problem, and I'm far from being an expert in this.

 

Hoping for help.

 

TheDai

[GarthMJ]

Did you rename the server after installing SQL?

Is both the CM12 database and the SQL server SQL_Latin1_General_CP1_CI_AS collation?

[j_seet]

Is this the default instance on your sql seever and theres no other instance installed?

 

I struggled with getting my 2nd instance recognized by sccm the first time I installed it. Turned out to be dynamic ports but that's another issue.

[TheDai]

Problem solved.

 

Turned out the issue was a severe case of "my own stupidity".

 

We reinstalled the SQL Server and found out that SQL_Latin1_General_CP1_CI_AS is the american standard, while the european version has a slightly different one.

 

Kind of funny. Or not.

Anyway, after days of pure despair, the SCCM is _installed_ ! Now I get to configure it and hope it'll be easier.

 

Thanks for your answers.

 

TheDai