Installation of a new instance of SQL Server 2019 developer edition related problems

%3CLINGO-SUB%20id%3D%22lingo-sub-2631492%22%20slang%3D%22en-US%22%3EInstallation%20of%20a%20new%20instance%20of%20SQL%20Server%202019%20developer%20edition%20related%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2631492%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20learning%20to%20work%20with%20SQL%20server%202019.%20I%20am%20new%20to%20SQL.%20I%20am%20learning%20from%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZNObiptSMSI%26amp%3Blist%3DPL08903FB7ACA1C2FB%26amp%3Bindex%3D1%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%3C%2FP%3E%3CP%3EDuring%20the%20installation%20I%20got%20some%20errors.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ETITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%0A------------------------------%0A%0AThe%20following%20error%20has%20occurred%3A%0A%0ACannot%20find%20the%20user%20'DESKTOP-QGVGUB6%5CPdwComputeNodeAccess'%2C%20because%20it%20does%20not%20exist%20or%20you%20do%20not%20have%20permission.%0AChanged%20database%20context%20to%20'DWConfiguration'.%0A%20%0AScript%20version%3A%20107%0AVersion_History%20table%20created.%0ACurrently%20stored%20version%3A%200%0ANeed%20to%20run%20SP%20and%20insert%20value%20into%20the%20version_history%20table%3A%20107%0ADatabase%20name%20is%3A%20DWConfiguration%0ACurrent%20Version%3A0%0ADatabase%20name%20is%3A%20DWDiagnostics%0A%0AClick%20'Retry'%20to%20retry%20the%20failed%20action%2C%20or%20click%20'Cancel'%20to%20cancel%20this%20action%20and%20continue%20setup.%0A%0AFor%20help%2C%20click%3A%20https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.4013.40%26amp%3BEvtType%3D0x7590AFD6%2525400x9A41B222%0A%0A------------------------------%0ABUTTONS%3A%0A%0A%26amp%3BRetry%0ACancel%0A------------------------------%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20another%20error%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ETITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%0A------------------------------%0A%0AThe%20following%20error%20has%20occurred%3A%0A%0ACannot%20find%20the%20user%20'DESKTOP-QGVGUB6%5CPdwComputeNodeAccess'%2C%20because%20it%20does%20not%20exist%20or%20you%20do%20not%20have%20permission.%0AThe%20WITH%20MARK%20option%20only%20applies%20to%20the%20first%20BEGIN%20TRAN%20WITH%20MARK%20statement.%20The%20option%20is%20ignored.%0AChanged%20database%20context%20to%20'DWConfiguration'.%0A%20%0AScript%20version%3A%20107%0ACurrently%20stored%20version%3A%200%0ANeed%20to%20run%20SP%20and%20insert%20value%20into%20the%20version_history%20table%3A%20107%0ADatabase%20name%20is%3A%20DWConfiguration%0ACurrent%20Version%3A0%0ADatabase%20name%20is%3A%20DWDiagnostics%0A%0AClick%20'Retry'%20to%20retry%20the%20failed%20action%2C%20or%20click%20'Cancel'%20to%20cancel%20this%20action%20and%20continue%20setup.%0A%0AFor%20help%2C%20click%3A%20https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.4013.40%26amp%3BEvtType%3D0x7590AFD6%2525400x9A41B222%0A%0A------------------------------%0ABUTTONS%3A%0A%0A%26amp%3BRetry%0ACancel%0A------------------------------%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20was%20a%20fresh%20install.%20To%20fix%26nbsp%3BFix%20Wmi%20performance%20counters%20I%20read%20here%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Ftroubleshoot%2Fwindows-server%2Fperformance%2Frebuild-performance-counter-library-values%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Ftroubleshoot%2Fwindows-server%2Fperformance%2Frebuild-performance-counter-library-values%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ebut%20now%20as%20per%20instructions%20in%20Windows%20install%20disc%20I%20did%20not%20get%20to%20see%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20i386%20folder%20in%20Windows%20installation%20disc%20available%20to%20me.%26nbsp%3B%3C%2FP%3E%3CP%3Esearched%20for%20perfc009.da_%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENow%20I%20tried%20second%20thing%20editing%20registry%20values%20as%20explained%20on%20above%20link%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Ftroubleshoot%2Fwindows-server%2Fperformance%2Frebuild-performance-counter-library-values%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Ftroubleshoot%2Fwindows-server%2Fperformance%2Frebuild-performance-counter-library-values%3C%2FA%3E%3C%2FP%3E%3CP%3Etried%20running%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3Blodctr%20%2Fr%20in%20system32%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%20read%20here%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFrom%20the%20link%20%22Cannot%20load%20Counter%20Name%20data...%22%20error%20message%20appears%20when%20manually%20installing%20TMSMMainService.exe%20-%20Apex%20One%20(Mac)%20(trendmicro.com)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsuccess.trendmicro.com%2Fsolution%2F000152298%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsuccess.trendmicro.com%2Fsolution%2F000152298%3C%2FA%3E%3C%2FP%3E%3CP%3Ebut%20since%20I%20could%20not%20fix%20any%20thing%20so%20I%26nbsp%3B%3CSPAN%3EI%20used%20revo%20uninstaller%20(trial%20version)%20to%20uninstall%20every%20thing%20because%20from%20control%20panel%20I%20was%20not%20able%20to%20uninstall.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20time%20again%20a%20fresh%20installation%20I%20tried%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ETITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%0A------------------------------%0A%0AThe%20following%20error%20has%20occurred%3A%0A%0ANo%20mapping%20between%20account%20names%20and%20security%20IDs%20was%20done.%0A%0A%0AClick%20'Retry'%20to%20retry%20the%20failed%20action%2C%20or%20click%20'Cancel'%20to%20cancel%20this%20action%20and%20continue%20setup.%0A%0AFor%20help%2C%20click%3A%20https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.4013.40%26amp%3BEvtType%3D0x0F90E2F6%2525400xDC80C325%0A%0A------------------------------%0ABUTTONS%3A%0A%0A%26amp%3BRetry%0ACancel%0A------------------------------%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20another%20error%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ETITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%0A------------------------------%0A%0AThe%20following%20error%20has%20occurred%3A%0A%0AThe%20MOF%20compiler%20could%20not%20connect%20with%20the%20WMI%20server.%20This%20is%20either%20because%20of%20a%20semantic%20error%20such%20as%20an%20incompatibility%20with%20the%20existing%20WMI%20repository%20or%20an%20actual%20error%20such%20as%20the%20failure%20of%20the%20WMI%20server%20to%20start.%0A%0AFor%20help%2C%20click%3A%20https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.4013.40%26amp%3BEvtType%3D0xA60E3551%2525400xD3BEBD98%2525401211%2525401%0A%0A------------------------------%0ABUTTONS%3A%0A%0AOK%0A------------------------------%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstallation%20succedded%20with%20failure%20in%26nbsp%3B%3C%2FP%3E%3CP%3EDatabase%20engine%20services%3C%2FP%3E%3CP%3ESQL%20Server%20Replication%3C%2FP%3E%3CP%3EAnalysis%20Services%3C%2FP%3E%3CP%3EDistributed%20Replay%20controller%3C%2FP%3E%3CP%3EClient%20tools%20backward%20compatibility%3C%2FP%3E%3CP%3EClient%20tools%20connectivity%3C%2FP%3E%3CP%3EScale%20out%20worker%3C%2FP%3E%3CP%3EScale%20out%20master%3C%2FP%3E%3CP%3EIntegration%20Services%3C%2FP%3E%3CP%3Eall%20above%20failed%20at%20the%20end%20of%20installation%3C%2FP%3E%3CP%3EThen%20as%20suggested%20on%20this%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Finsider%2Fforum%2Fall%2Fpossible-performance-counter-problem-on-win10%2F3a5c22cb-1425-4d26-99e7-4ec46940b9a1%3Fauth%3D1%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eforum%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20tried%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ERebuilding%20the%20counters%3A%0A%0A%20%20%20%20%20cd%20c%3A%5Cwindows%5Csystem32%0A%0A%20%20%20%20%20lodctr%20%2FR%0A%0A%20%20%20%20%20cd%20c%3A%5Cwindows%5CsysWOW64%0A%0A%20%20%20%20%20lodctr%20%2FR%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20not%20tried%20below%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EResyncing%20the%20counters%20with%20Windows%20Management%20Instrumentation%20(WMI)%3A%0A%0A%20%20%20%20%20WINMGMT.EXE%20%2FRESYNCPERF%0A%0AStop%20and%20restart%20the%20Performance%20Logs%20and%20Alerts%20service.%20%0A%0AStop%20and%20restart%20the%20Windows%20Management%20Instrumentation%20service.%0A%0ACreate%20a%20new%20Data%20Collector%20Set%20(do%20not%20use%20an%20existing%20Data%20Collector%20Set).%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebecause%20I%20could%20not%20understand%20instructions.%3C%2FP%3E%3CP%3Esearched%20on%20internet.%3C%2FP%3E%3CP%3Ewith%20this%20link%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.thewindowsclub.com%2Fhow-to-repair-or-rebuild-the-wmi-repository-on-windows-10%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.thewindowsclub.com%2Fhow-to-repair-or-rebuild-the-wmi-repository-on-windows-10%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20did%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EC%3A%5CWindows%5Csystem32%26gt%3Blodctr%20%2FR%0A%0AInfo%3A%20Successfully%20rebuilt%20performance%20counter%20setting%20from%20system%20backup%20store%0AC%3A%5CWindows%5Csystem32%26gt%3Bwinmgmt%20%2Fverifyrepository%0AWMI%20repository%20is%20consistent%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20it%20seems%20WMI%20repository%20is%20fine.%3C%2FP%3E%3CP%3EI%20however%20uninstalled%20all%20instance%20of%20SQL%20Server%202019%20what%20ever%20I%20could%20see%20in%20Control%20Panel%20program%20and%20features.%3C%2FP%3E%3CP%3EAgain%20started%20installing%20from%20scratch.%20I%20got%20validation%20error.%20While%20installing%20SQL%20server%202019%20developer%20edition%20this%26nbsp%3B%20time.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20now%20did%20following%3C%2FP%3E%3CP%3E1.%20Uninstall%20all%20SQL%20Server%20components%20you%20can%20using%20Control%20Panel%20-%26gt%3B%20Programs%20and%20Features%3C%2FP%3E%3CP%3E2.%20Backup%20the%20registry.%3C%2FP%3E%3CP%3E3.%20Delete%20the%20following%20keys%20in%20regedit%3A%3C%2FP%3E%3CP%3E--HKEY_LOCAL_MACHINE%5CSOFTWARE%5CMicrosoft%5CMicrosoft%20SQL%20Server%3C%2FP%3E%3CP%3E--HKEY_LOCAL_MACHINE%5CSOFTWARE%5CMicrosoft%5CMSSQLServer%3C%2FP%3E%3CP%3E4.%20Go%20to%20HKEY_LOCAL_MACHINE%5CSOFTWARE%5CMicrosoft%5CWindows%5CCurrentVersion%5CUninstall%20and%20delete%20all%20the%20sub-keys%20referencing%20SQL%20Server.%3C%2FP%3E%3CP%3E5.%20Go%20to%20HKEY_LOCAL_MACHINE%5CSYSTEM%5CCurrentControlSet%5CServices%20and%20delete%20all%20the%20keys%20referencing%20SQL%20Server.%3C%2FP%3E%3CP%3E6.%20Deleted%20all%20the%20SQL%20Server%20folders%20in%20the%20computer%20C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%20and%20subfolders.%3C%2FP%3E%3CP%3EI%20started%20a%20fresh%20installation.%20Now%20I%20get%20following%20errors%20during%20installation%3C%2FP%3E%3CP%3Eerror%201%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ETITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%0A------------------------------%0A%0AThe%20following%20error%20has%20occurred%3A%0A%0AUnable%20to%20open%20registry%20key%3A%20'Software%5CMicrosoft%5CMicrosoft%20SQL%20Server%5C150%5CBootstrap'%2C%20registry%20may%20be%20corrupted.%0A%0AFor%20help%2C%20click%3A%20https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.2000.5%26amp%3BEvtType%3D0x935EEB66%2525400xBC33138D%2525401236%2525402%0A%0A------------------------------%0ABUTTONS%3A%0A%0AOK%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eerror2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ETITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%0A------------------------------%0A%0AThe%20following%20error%20has%20occurred%3A%0A%0AThe%20MOF%20compiler%20could%20not%20connect%20with%20the%20WMI%20server.%20This%20is%20either%20because%20of%20a%20semantic%20error%20such%20as%20an%20incompatibility%20with%20the%20existing%20WMI%20repository%20or%20an%20actual%20error%20such%20as%20the%20failure%20of%20the%20WMI%20server%20to%20start.%0A%0AFor%20help%2C%20click%3A%20https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.2000.5%26amp%3BEvtType%3D0xA60E3551%2525400xD3BEBD98%2525401211%2525401%0A%0A------------------------------%0ABUTTONS%3A%0A%0AOK%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eerror%203%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%0A------------------------------%0A%0AThe%20following%20error%20has%20occurred%3A%0A%0APerfLib%202.0%20counter%20removal%20failed%20with%20exit%20code%202.%20Command%20line%3A%20C%3A%5CWindows%5Csystem32%5Cunlodctr.exe%20%2Fm%3Ahkengperfctr.xml%20from%20directory%20C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%5C150%5CShared%5C.%0A%0AFor%20help%2C%20click%3A%20https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.2000.5%26amp%3BEvtType%3D0x590D6427%2525400x24BDAA65%2525401260%2525401%0A%0A------------------------------%0ABUTTONS%3A%0A%0AOK%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20able%20to%20understand%20What%20should%20I%20do%20more%20now.%3C%2FP%3E%3CP%3EThis%20is%20a%20fresh%20install%20and%20I%20am%20new%20to%20SQL.%3C%2FP%3E%3CDIV%20class%3D%22grid__col%20grid__col--span-9-of-12%20grid__col--push-1-of-12%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

I am learning to work with SQL server 2019. I am new to SQL. I am learning from here

During the installation I got some errors. 

 

TITLE: Microsoft SQL Server 2019 Setup
------------------------------

The following error has occurred:

Cannot find the user 'DESKTOP-QGVGUB6\PdwComputeNodeAccess', because it does not exist or you do not have permission.
Changed database context to 'DWConfiguration'.
 
Script version: 107
Version_History table created.
Currently stored version: 0
Need to run SP and insert value into the version_history table: 107
Database name is: DWConfiguration
Current Version:0
Database name is: DWDiagnostics

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x7590AFD6%25400x9A41B222

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------

 

Then another error 

 

TITLE: Microsoft SQL Server 2019 Setup
------------------------------

The following error has occurred:

Cannot find the user 'DESKTOP-QGVGUB6\PdwComputeNodeAccess', because it does not exist or you do not have permission.
The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.
Changed database context to 'DWConfiguration'.
 
Script version: 107
Currently stored version: 0
Need to run SP and insert value into the version_history table: 107
Database name is: DWConfiguration
Current Version:0
Database name is: DWDiagnostics

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x7590AFD6%25400x9A41B222

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------

 

This was a fresh install. To fix Fix Wmi performance counters I read here  https://docs.microsoft.com/en-us/troubleshoot/windows-server/performance/rebuild-performance-counter...

but now as per instructions in Windows install disc I did not get to see 

any i386 folder in Windows installation disc available to me. 

searched for perfc009.da_ 

Now I tried second thing editing registry values as explained on above link https://docs.microsoft.com/en-us/troubleshoot/windows-server/performance/rebuild-performance-counter...

tried running 

 lodctr /r in system32 

and read here 

From the link "Cannot load Counter Name data..." error message appears when manually installing TMSMMainService.exe - Apex One (Mac) (trendmicro.com)

https://success.trendmicro.com/solution/000152298

but since I could not fix any thing so I I used revo uninstaller (trial version) to uninstall every thing because from control panel I was not able to uninstall.

This time again a fresh installation I tried 

 

TITLE: Microsoft SQL Server 2019 Setup
------------------------------

The following error has occurred:

No mapping between account names and security IDs was done.


Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x0F90E2F6%25400xDC80C325

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------

 

and another error 

 

TITLE: Microsoft SQL Server 2019 Setup
------------------------------

The following error has occurred:

The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xA60E3551%25400xD3BEBD98%25401211%25401

------------------------------
BUTTONS:

OK
------------------------------

 

Installation succedded with failure in 

Database engine services

SQL Server Replication

Analysis Services

Distributed Replay controller

Client tools backward compatibility

Client tools connectivity

Scale out worker

Scale out master

Integration Services

all above failed at the end of installation

Then as suggested on this forum 

 

I had tried 

 

Rebuilding the counters:

     cd c:\windows\system32

     lodctr /R

     cd c:\windows\sysWOW64

     lodctr /R

 

I did not tried below 

 

Resyncing the counters with Windows Management Instrumentation (WMI):

     WINMGMT.EXE /RESYNCPERF

Stop and restart the Performance Logs and Alerts service. 

Stop and restart the Windows Management Instrumentation service.

Create a new Data Collector Set (do not use an existing Data Collector Set).

 

because I could not understand instructions.

searched on internet.

with this link https://www.thewindowsclub.com/how-to-repair-or-rebuild-the-wmi-repository-on-windows-10

I did

 

C:\Windows\system32>lodctr /R

Info: Successfully rebuilt performance counter setting from system backup store
C:\Windows\system32>winmgmt /verifyrepository
WMI repository is consistent

 

so it seems WMI repository is fine.

I however uninstalled all instance of SQL Server 2019 what ever I could see in Control Panel program and features.

Again started installing from scratch. I got validation error. While installing SQL server 2019 developer edition this  time. 

I now did following

1. Uninstall all SQL Server components you can using Control Panel -> Programs and Features

2. Backup the registry.

3. Delete the following keys in regedit:

--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.

5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.

6. Deleted all the SQL Server folders in the computer C:\Program Files\Microsoft SQL Server and subfolders.

I started a fresh installation. Now I get following errors during installation

error 1

 

TITLE: Microsoft SQL Server 2019 Setup
------------------------------

The following error has occurred:

Unable to open registry key: 'Software\Microsoft\Microsoft SQL Server\150\Bootstrap', registry may be corrupted.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.2000.5&EvtType=0x935EEB66%25400xBC33138D%25401236%25402

------------------------------
BUTTONS:

OK

 

 

 

error2

 

TITLE: Microsoft SQL Server 2019 Setup
------------------------------

The following error has occurred:

The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.2000.5&EvtType=0xA60E3551%25400xD3BEBD98%25401211%25401

------------------------------
BUTTONS:

OK

 

error 3

 

ITLE: Microsoft SQL Server 2019 Setup
------------------------------

The following error has occurred:

PerfLib 2.0 counter removal failed with exit code 2. Command line: C:\Windows\system32\unlodctr.exe /m:hkengperfctr.xml from directory C:\Program Files\Microsoft SQL Server\150\Shared\.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.2000.5&EvtType=0x590D6427%25400x24BDAA65%25401260%25401

------------------------------
BUTTONS:

OK

 

I am not able to understand What should I do more now.

This is a fresh install and I am new to SQL.

 
1 Reply
Ok I have been able to solve this. First I uninstalled every thing using an revo uninstaller and scanned for left over items of registry and empty folders with revo uninstaller. Then
For fresh installation
I did 2 things..
1) the installation files meaning exe and cab files of SQL Server I had extracted from the downloaded iso had blank space in name
C:\Users\koidera\arbit_user\softwares\sql server\exe and cab files of sql server 2019
I changed this to
C:\Users\koidera\arbit_user\softwares\sql_server\exe_and_cab_files_of_sql_server_2019
2) I was double clicking the setup file as normal user what I should have been doing is run as admin.
Every thing has worked perfectly this time
and every thing is installed all with green ticks.