Really, I am struggling with the error while installing CM 2002 on Srv 2019.

What’s your recommandation about the configuration of the Database?
What’s size, how many files?

What are your recommandation about the database files?
Temp file?

That’s nice..

Hi, Finally I’ve done with my installation, i think so SCCM Setup files may be corrupted so re-downloaded setup package and its now working for me…and get installation done finally.

Many Thanks..

INFO: Executing SQL Server Script: Create object fngetsitetablecheckconstraintstatements $$
INFO: Executing SQL Server Script: Create object fncompareuk $$
INFO: Executing SQL Server Script: Create object fnispknull $$
INFO: Executing SQL Server Script: Create object spcolltrackchangesforcollections $$
INFO: Executing SQL Server Script: Create object sp_createresourcefunction $$
INFO: Executing SQL Server Script: Create object sp_createresourceview $$
INFO: Executing SQL Server Script: Create object sprefreshallresourceviews $$
INFO: Executing SQL Server Script: Create object fngetsitetablefkrefconstraintstatements $$
INFO: Executing SQL Server Script: Create object spaddpartitionscheme $$
INFO: Executing SQL Server Script: Create object fncreatecolumnsfullex $$
INFO: Executing SQL Server Script: Create object spcreatedbmasterkey $$
INFO: Executing SQL Server Script: Create object spcreateandbackupsqlcert $$
INFO: Executing SQL Server Script: Create object sprenewssbcertificate $$
INFO: Executing SQL Server Script: Create object spconfigurefkforglobaltablespergroup $$
INFO: Executing SQL Server Script: Create object fngetsitetabledefaultconstraintstatements $$
INFO: Executing SQL Server Script: Create object fngettabletriggers $$
INFO: Executing SQL Server Script: Create object fngetsitetablefkconstraintstatements $$
INFO: Executing SQL Server Script: Create object fnquerycolumns $$
INFO: Executing SQL Server Script: Create object sprethrowerror $$
INFO: Executing SQL Server Script: Create object spconfiguresqldistributorandpublisher $$
INFO: Executing SQL Server Script: Create object spgeneratesiteapplicationdeleteupsertprocs $$
INFO: Executing SQL Server Script: Create object sp_removeinventoryview $$
INFO: Executing SQL Server Script: Create object fnisvalidsitetabletopartition $$
INFO: Executing SQL Server Script: Create object fnprimarykeycolumnswithdir $$
INFO: Executing SQL Server Script: Create object fngetsitetableuniquekeyconstraints $$
INFO: Executing SQL Server Script: Create object fngetsitetableindexstatements $$
INFO: Executing SQL Server Script: Create object fncreatecolumnsfull $$
INFO: Executing SQL Server Script: Create object fngetsitetableukconstraintstatements $$
INFO: Executing SQL Server Script: Create object spconfiguresitepartitiontable $$
INFO: Executing SQL Server Script: Create object spconfigurecasforsitepartitiontable $$
INFO: Executing SQL Server Script: Create object fnprimarykeycolumns $$
INFO: Executing SQL Server Script: Create object fnuniquekeycolumns $$
INFO: Executing SQL Server Script: Create object fnnecomparepk $$
INFO: Executing SQL Server Script: Create object spgeneratechangeapplicationdeleteupsertprocs $$
INFO: Executing SQL Server Script: Create object spsedoconfigurelockableobjecttypes $$
INFO: Executing SQL Server Script: Create object vdrstables $$
INFO: Executing SQL Server Script: Create object vdrstableswithidentity $$
INFO: Executing SQL Server Script: Create object spdrscreategetfunctionsec $$
INFO: Executing SQL Server Script: Create object spconfigureservicebroker $$
INFO: Executing SQL Server Script: Create object spaddpartitioncheckconstraint $$
INFO: Executing SQL Server Script: Create object sp_createcollectionview $$
INFO: Executing SQL Server Script: Create object sp_createcollectionviewandfunction $$
INFO: Executing SQL Server Script: Create object sp_renewcollectionviews $$
INFO: Executing SQL Server Script: Create object spdrscreategetfunctionsecex $$
INFO: Executing SQL Server Script: Create object spdrscreategetfunctions $$
INFO: Executing SQL Server Script: Create object spdrsregeneratealldrssprocsandfuncs $$
INFO: Executing SQL Server Script: Create object fn1primarykeycolumn $$
INFO: Executing SQL Server Script: Create object spgenerateaudittriggers $$
INFO: Executing SQL Server Script: Create object spextrenewinvgroupextractviews $$
INFO: Executing SQL Server Script: Create object sp_renewresourceviews $$
INFO: Executing SQL Server Script: Create object spdrsresetlastversionsenttosite $$
INFO: Executing SQL Server Script: Create object spupgraderesetlastversionsentforallconnectedsites $$
INFO: Executing SQL Server Script: Create object sp_renewinvgroupviews $$
INFO: Executing SQL Server Script: Create object sp_renewsmsschemaviews $$
INFO: Executing SQL Server Script: Create object splogerror $$
INFO: Executing SQL Server Script: Create object spupdatessbroutes $$
INFO: Executing SQL Server Script: Create object spconfigurereplication $$
INFO: Executing SQL Server Script: Create object spconfigurecasforsitepartitiontables $$
INFO: Executing SQL Server Script: Create object spconfigurefkforglobaltables $$
INFO: Configuring database replication… $$
INFO: SQL Connection succeeded. Connection: DC01.RIMDC.COM CM_RN1, Type: Secure $$
INFO: Importing Asset Intelligence data. $$
INFO: SQL Connection succeeded. Connection: DC01.RIMDC.COM CM_RN1, Type: Secure $$
INFO: Starting to import data from CSV files… $$
INFO: Successfully created the dir D:\SCCMROOT\AI~ $$
INFO: Successfully retrieved data file, now expanding $$
INFO: Counted 9 files in AI cabfile $$
INFO: Extracted file D:\SCCMROOT\AI\LU_LicensedProduct.csv $$
INFO: Extracted file D:\SCCMROOT\AI\LU_Category.csv $$
INFO: Extracted file D:\SCCMROOT\AI\LU_HardwareRequirements.csv $$
INFO: Extracted file D:\SCCMROOT\AI\LU_MSProd.csv $$
INFO: Extracted file D:\SCCMROOT\AI\LU_SoftwareCode.csv $$
INFO: Extracted file D:\SCCMROOT\AI\LU_SoftwareHash.csv $$
ERROR(13): Failed to iterate cab file.~ $$
ERROR(13): Failed to expand the look up table files to the folder: D:\SCCMROOT\AI.~ $$
ERROR: Failed to import Asset Intelligence data into the site database.~ $$
~~===================== Completed Configuration Manager 2012 Server Setup ===================== $$
*****************************************************
***** Exiting ConfigMgr 2012 Setup Bootstrapper *****
*****************************************************

I’ve installed all per-requisites ADK & UMT Tools kits, MS SQL 2012 with CU2. but now durring SCCM 2012 SP1 setup its error logs says that unable to create some tables on MSSQLSERVER SQL database, that’s why fails to create SCCM Database which causes failure to setup SCCM 2012 SP1 setup.
I’ve installed SQL Server and configured all sql services running with Domain User which is SCCM Admin.

My posts on SCCM 2012 SP1 are on the way..

I believe you are installing SCCM 2012 SP1. As a prerequisite you have to download and install Windows Assessment and Deployment Kit for Windows 8 which can be downloaded from Microsoft.
Once downloaded, install Deployment tools, Windows PE and USMT.