"Failed to find folder" or "Failed to find file" error when you move a ConfigMgr site database

When you do site maintenance to move a Configuration Manager site database to a new standalone instance of Microsoft SQL Server, or to a new SQL Server AlwaysOn availability group, the Configuration Manager setup process fails and generates error messages that resemble the following in the ConfigMgrSetup.log.

Error message 1

INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure
INFO: SQL Server Native Client: SQLNCLI11 version:<11.0.2100.60>
ERROR: Failed to find folder of SQL Server assembly setup msi.

Error message 2

ERROR: SQL Connection failed. Connection: SMS ACCESS, Type: Secure
ERROR: Failed to get SQL Server connection.
INFO: SQL Server Native Client: SQLNCLI11 version:<11.2.5641.0>
ERROR: Failed to find file: c:\temp\redist\msxml6_x64.msi.
This problem can occur if Configuration Manager cannot find the required files. Typically this is because of an invalid registry key value for the following subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Setup\External File Directory
To work around this problem, use Setupdl.exe to download the required files to a locally accessible folder. The version of Setupdl.exe that you use must match the version of the site so that the correct files are downloaded. Setupdl.exe will automatically update the registry value to have the new, correct download path.

A site-matching version of Setupdl.exe can be found in the cd.latest folder in the following location on the site server:

<InstallationDrive>:\Program Files\Microsoft Configuration Manager\cd.latest\SMSSETUP\BIN\X64\setupdl.exe

For environments where the site servers cannot access the Internet, you can run Setupdl.exe from an Internet-connected system, copy the required files to the site server, then manually update the subkey that's mentioned in the "Cause" section above.
More information
Microsoft is researching this problem and will post more information in this article as it becomes available.
ConfigMgr 1511 ConfigMgr 1602 SCCM

Article ID: 3189594 - Last Review: 09/23/2016 15:43:00 - Revision: 3.0

System Center Configuration Manager (current branch), System Center Configuration Manager, v1511 released November 2015, System Center Configuration Manager, v1602 released March 2016

  • kbexpertiseadvanced kbsurveynew kbprb KB3189594