Installing CM2012: resolving Odd prereuiqsite check failures

[Tuomas järvinen]

Hi!

I have tired to install the System Center Configuration manager 2012 for couple of days. There is some prerequisite checks that II can not understand or resolve. Our plan is to use our failower clustered database on "DBCFGMGR" and some virtual servers ("CMSRV1", "CMSRV2") for site system roles.

 

Most annoying problem is that if I run following:

\SMSSETUP\BIN\X64>prereqchk.exe /PRI /SQL dbcfgmgr.corp.local /SDK cmsrv1.corp.local /MP cmsrv1.corp.local /DP cmsrv2.corp.local

 

Gives different kind of results compared to setup.exe.

 

prereqchk = with prereqchk.exe

setup = with setup.exe

 

 

prereqchk: SQL service running account:

status failed,system CMSRV1

 

prereqchk, Required SQL server Collation

status failed, system: CMSRV1

 

prereqchk, setup SQL server sysadmin rights,

status failed, system: CMSRV1

 

setup: SQL Process memory allocation

status: warning, System DBCFGMGR

 

and some times

prereq: site system to SQL server comunication:

status warning, system CMSRV1

 

 

On CMSRV1 there is no or I can not find any SQL server (enterprise, express, datacenter nor starndard) installtion: Verified with looking

- control panel -> programs and features, none

- computer management -> services, none

- attempted to find any sql.exe from local computer. None

 

 

So, what can I do?

CMSRV1 and CMSRV2 are hosted on hyper-V, DB cluster is running dedicated hardware and it's working fine (running 3 other databases allready).

 

With Thanks,

Tuomas.

[Tuomas järvinen]

We was able to solve it by triple-checking SQL server collation.

 

For some annoying reason, Prerequisite checker allways incorrectly informed SYSTEM for incorrect database collation.

 

Bit of pain... Now SCCM is set up and seems to work...