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:
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:
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.
Microsoft is researching this problem and will post more information in this article as it becomes available.