SCCM ConfigMgr Remote SQL Site System server SMS Executive component Installation failed. Recently Microsoft has released SCCM ConfigMgr. More details about CU3 in the post-Download Install SCCM ConfigMgr 2012 R2 CU3 and Stop MP Rotation plus Partial WSUS Sync Issue. SCCM was installed successfully on the primary site.
However, we’ve noticed that MonitoringOverviewSystem StatusComponent Status is critical against SQL Site Server. As part of the SCCM ConfigMgr 2012 R2 CU3 installation (site reset), the SQL server SMS executive component was supposed to get reinstalled. However, the reinstallation was not successful.
SCCM ConfigMgr Remote SQL Site System server SMS Executive component Installation failed
SiteComp.log
Validated the SiteComp.log at the primary server, giving the following error. The exact issue is not represented in the log file. Logfile says rolesetup.exe is missing, but it was present in the location 🙂
So there could be some other reason for the SMS Executive Component of the SCCM 2012 Site System Server being unhealthy. Well, We’ll come to that in a minute. SCCM ConfigMgr Remote SQL Site System server SMS Executive component Installation failed.
STATMSG: ID=1083 SEV=E LEV=D SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=ACNCMPRISQL.ConfigMgr.com SITE=PRI PID=5616 TID=6872 GMTDATE=Thu Sep 25 23:17:21.181 2014 ISTR0="SMS_SERVER_BOOTSTRAP_ACNCMPRI" ISTR1="ACNCMPRISQL.ConfigMgr.com" ISTR2="ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe" ISTR3="/deinstall" ISTR4="" ISTR5="The file "ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe" does not exist." ISTR6="SMS_SRS_REPORTING_POINT" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0
Execution of "ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe /deinstall /siteserver:ACNCMPRI.ConfigMgr.com" on server ACNCMPRISQL.ConfigMgr.com failed: The file "ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe" does not exist.
I tried taking MSTSC (RDP) of the SQL Server, and an interesting error came. I could not take the remote, and it was giving me the following error. What to do next?
“Remote Desktop cannot verify the identity of the remote computer because there is a time or date difference between your computer and the remote computer. Make sure your computer’s clock is set to the correct time, and then try connecting again; contact your network administrator or the owner of the remote computer”.
I did some research (search) on the error mentioned above. What could be the issue? Nothing much was found apart from some of the Windows 7 Operating System articles. However, our SCCM ConfigMgr 2012 SQL server is Windows Server 2008 R2.
Troubleshooting
I tried the same old solution, “restarting the server,” as troubleshooting. The next question was How to restart the server when you’re not able to take RDP (MSTSC), and you don’t have ILO details of the server? “Shutdown -i” command was a suitable option for restarting the server.
After the restart of the SCCM ConfigMgr SQL DB server, I was able to log in to the server. I had checked the log files (SMSExec.log, CompMon.log, etc..) located at “SMSLogs”, none of the logs were updated since SCCM ConfigMgr 2012 R2 CU3 update on the primary server.
What next? I don’t want to wait until the next reinstall efforts from the SCCM ConfigMgr site server to the remote SQL site system server. I had bounced back the services (SMS Executive and SMS Component). Phewww … That is it 🙂 SCCM ConfigMgr Remote SQL Site System server SMS Executive component Installation failed.
The server was able to find the “rolesetup.exe”, which was missing last time around 🙂 After a few minutes, the SQL server SMS Executive component was successfully reinstalled, and “all is well” now !! Following are some lines of SiteComp.log at the SCCM ConfigMgr 2012 primary server after the restart.
ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe /deinstall /siteserver:ACNCMPRI." executed successfully on server ACNCMPRISQL.ConfigMgr.com.
Starting service SMS_SERVER_BOOTSTRAP_ACNCMPRI with command-line arguments "PRI D:SMS /deinstall ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe SMSSRSRP 262171
ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe /install /siteserver:ACNCMPRI.REG." executed successfully on server ACNCMPRISQL.ConfigMgr.com.
Installed file ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe. Starting service SMS_SERVER_BOOTSTRAP_ACNCMPRI with command-line arguments "PRI D:SMS /install ACNCMPRISQL.ConfigMgr.comD$SMSbinx64rolesetup.exe SMSSRSRP 262171
Resources
SCCM Related Posts Real World Experiences Of SCCM Admins (anoopcnair.com)
Author
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…