SCCM/MECM Stuck at "SQL Server service running account" prereq check

%3CLINGO-SUB%20id%3D%22lingo-sub-1453012%22%20slang%3D%22en-US%22%3ESCCM%2FMECM%20Stuck%20at%20%22SQL%20Server%20service%20running%20account%22%20prereq%20check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1453012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EThe%20issue%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EI'm%20not%20getting%20through%20the%20Prerequisite%20checks%20for%20MECM.%20The%20biggest%20struggle%20is%20the%20SQL%20check%20stating%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESQL%20Server%20service%20running%20account%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CEM%3E%22The%20logon%20account%20for%20the%20SQL%20Server%20service%20cannot%20be%20a%20local%20user%20account%2C%20NT%20SERVICE%5C%3CSQL%20service%3D%22%22%20name%3D%22%22%3E%20or%20LOCAL%20SERVICE.%20You%20must%20configure%20the%20SQL%20Server%20service%20to%20use%20a%20valid%20domain%20account%2C%20NETWORK%20SERVICE%2C%20or%20LOCAL%20SYSTEM.%22%3C%2FSQL%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20a%20screenshot%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-06-10%2009_02_49-Window.jpg%22%20style%3D%22width%3A%20740px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197819iD3BB746ACBFCD752%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-06-10%2009_02_49-Window.jpg%22%20alt%3D%222020-06-10%2009_02_49-Window.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20Configuration%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EThis%20is%20a%20brand%20new%20CM%20setup%20(there%20was%20no%20CM%20in%20the%20past)%2C%20so%20I've%20chosen%20to%20Install%20the%20primary%20site%20as%20a%20stand-alone%20site.%3CBR%20%2F%3EAll%20CM%20Roles%20on%20a%20single%20server%20named%20CM01%3CBR%20%2F%3EDatabase%20is%20a%20Named%20instance%20in%20our%20SQL%20server%20failover%20cluster%20(running%20with%20separate%20Domain%20accounts%20for%20the%20DBE%20and%20SSA)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EMy%20Toughts%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EIt%20seems%20that%20de%20CM%20Setup%20wizard%20is%20trying%20to%20perform%20it's%20prereq%20checks%20assuming%20that%20SQL%20is%20locally%20installed%2C%20and%20therefore%20it%20fails%20on%20this%20prereq%20check.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhat%20I've%20already%20tried%2Fchecked%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E-%20Of%20course%20I've%20searched%20the%20web%20for%20solution%2C%20and%20as%20stated%20above%20this%20has%20nothing%20to%20do%20with%20the%20SQL%20server%20instance%20running%20with%20local%20or%20system%20credentials%3CBR%20%2F%3E-%20Double%20checked%20if%20SQL%20is%20running%20with%20a%20Static%20port%2C%20and%20made%20sure%20SQL%20has%20the%20right%20collation%3CBR%20%2F%3E-%20No%20ports%20are%20blocking%20by%20Windows%20Firewall%20(on%20CM01%20and%20the%20SQL%20server)%3CBR%20%2F%3E-%20No%20ports%20are%20blocked%20by%20our%20network%20firewall%20(Checkpoint)%3CBR%20%2F%3E-%20Made%20sure%20port%20TCP%3A1433%2C%204022%2C%201434%20and%20UDP%3A1434%20are%20open%20and%20reachable%20between%20CM01%20and%20SQL%20and%20vice%20versa.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20that%20it's%20recommended%20to%20run%20the%20SQL%20DB%20on%20the%20CM%20server%20itself%20for%20performance%20reasons%2C%20but%20in%20this%20particular%20case%20it's%20needed%20to%20have%20it%20installed%20on%20the%20SQL%20Server%20Failover%20cluster%20(a%20company%20compliancy%20thing)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhat%20could%20be%20the%20cause%20of%20this%20issue%3F%20I'm%20really%20stuck%20on%20this%20one.%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1453012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConfiguration%20Manager%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESystem%20Center%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480330%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%2FMECM%20Stuck%20at%20%22SQL%20Server%20service%20running%20account%22%20prereq%20check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480330%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F666216%22%20target%3D%22_blank%22%3E%40mhvanderhoek%3C%2FA%3E%26nbsp%3BThere%20really%20is%20no%20formal%20recommendation%20to%20host%20the%20site%20database%20on%20the%20site%20server%20itself%2C%20and%20neither%20does%20ConfigMgr%20assume%20it's%20always%20there.%20In%20this%20case%2C%20it%20would%20seem%20that%20there's%20something%20wrong%20with%20the%20site%20database%20server%20configuration%20for%20your%20site.%20First%20thing%20I%20would%20do%20is%20check%20the%20C%3A%5CConfigMgrPrereq.log%20file%20on%20the%20site%20server%2C%20as%20this%20will%20probably%20contain%20a%20lot%20more%20detailed%20information%20about%20the%20reasons%20these%20checks%20are%20failing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480343%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%2FMECM%20Stuck%20at%20%22SQL%20Server%20service%20running%20account%22%20prereq%20check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480343%22%20slang%3D%22en-US%22%3EHi%20Michiel%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20your%20response%20i'll%20have%20a%20look%20at%20the%20logs.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

The issue:
I'm not getting through the Prerequisite checks for MECM. The biggest struggle is the SQL check stating:

 

SQL Server service running account
"The logon account for the SQL Server service cannot be a local user account, NT SERVICE\<sql service name> or LOCAL SERVICE. You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM."

 

Below a screenshot:
2020-06-10 09_02_49-Window.jpg

 

The Configuration:
This is a brand new CM setup (there was no CM in the past), so I've chosen to Install the primary site as a stand-alone site.
All CM Roles on a single server named CM01
Database is a Named instance in our SQL server failover cluster (running with separate Domain accounts for the DBE and SSA)

 

My Toughts:
It seems that de CM Setup wizard is trying to perform it's prereq checks assuming that SQL is locally installed, and therefore it fails on this prereq check.

 

What I've already tried/checked:
- Of course I've searched the web for solution, and as stated above this has nothing to do with the SQL server instance running with local or system credentials
- Double checked if SQL is running with a Static port, and made sure SQL has the right collation
- No ports are blocking by Windows Firewall (on CM01 and the SQL server)
- No ports are blocked by our network firewall (Checkpoint)
- Made sure port TCP:1433, 4022, 1434 and UDP:1434 are open and reachable between CM01 and SQL and vice versa.

 

I know that it's recommended to run the SQL DB on the CM server itself for performance reasons, but in this particular case it's needed to have it installed on the SQL Server Failover cluster (a company compliancy thing)

 

What could be the cause of this issue? I'm really stuck on this one.

2 Replies
Highlighted

@mhvanderhoek There really is no formal recommendation to host the site database on the site server itself, and neither does ConfigMgr assume it's always there. In this case, it would seem that there's something wrong with the site database server configuration for your site. First thing I would do is check the C:\ConfigMgrPrereq.log file on the site server, as this will probably contain a lot more detailed information about the reasons these checks are failing.

Highlighted
Hi Michiel,

Thanks for your response i'll have a look at the logs.