My client was installing SQL Server in the cluster. One first node they created a new failover clustered instance. On the second node, they were performing Add Node operation and it was failing with an error.
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Failed: see details below
MSI error code: 0x2AFCCCD0
MSI log file location: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20180220_114356\sql_as_Cpu64_1.log
MSI error description: The folder path ‘Program Files’ contains an invalid character.
If we look at the file name it is “sql_as” which means this is for analysis services. I looked at the log mentioned above and found that setup was looking for D drive on the new node. This was due to the fact that Program Files were installed on D drive on the first node.
It looked like this issue occurs if we have different drive letter names on both nodes of the cluster. For example, we install SQL Server binaries on D drive on one node. However, there is no D drive on the passive node.
- Uninstalled ALL SQL components that had been installed on passive node via the control
- Change the local drive letter on the passive node so that it matches to the local drive on the active node which contains SQL server binary files.
- Reboot the passive node and then re-run the setup.
This resolved the issue for my client. Have you encountered the similar error? What was the solution you opted for?
Reference: Pinal Dave (https://blog.sqlauthority.com)