SSMS installation fails with ODB.MSI failure

Question

My installation fails to look for the installation file
15.0.300.129.01 1031 sql_as_oledb.msi

[297C:2DB4][2021-02-08T10:21:33]e000: BootstrapperEngineDataModel.OnError: Burn engine encountered error. PackageId: sql_as_oledb_x64, ErrorType: WindowsInstaller, ErrorCode: 1714, Data: 1714,Microsoft Analysis Services OLE DB Provider,1612, ErrorMessage: The older version of Microsoft Analysis Services OLE DB Provider cannot be removed. Contact your technical support group. , UIHint: 0
[297C:2DB4][2021-02-08T10:21:33]i000: MainViewModel.AddFailedCondition: Error: Microsoft Analysis Services OLE DB Provider: The older version of Microsoft Analysis Services OLE DB Provider cannot be removed. Contact your technical support group.
[297C:2DB4][2021-02-08T10:21:33]e000: MainViewModel.OnPackageError: setup failed for packageId: sql_as_oledb_x64, package: Microsoft Analysis Services OLE DB Provider, errorCode: 1714, errorMessage: The older version of Microsoft Analysis Services OLE DB Provider cannot be removed. Contact your technical support group.

[297C:2DB4][2021-02-08T10:17:41]i000: Initializing string variable 'SetupFailedDescriptionText' to value 'A failure occured during installation.'
[297C:2DB4][2021-02-08T10:17:41]i000: Initializing string variable 'SetupFailedText' to value 'Setup Failed'

Answer 1

1. Search for the driver installer "15.0.300.129.01_1031_SQL_AS_OLEDB" in the registry
2. Rename the registry key GUID to something else
3. Rerun the installer. It won't complain because it can't find the reference.

Answer 2

Hi,

From the error description, it looks like you need to uninstall older version of Microsoft Analysis Services OLE DB Provider manually.

You could follow this thread to uninstall the provider. How to Uninstall/reinstall OLEDB providers for Analysis Services

After this you could try to install SSMS , see if it is successful.

Regards,
Lukas

Answer 3

You could firstly uninstall all the SSMS remain part in your system uninstall app list.
Then you could try download and install the newest version of SSMS 18.8? You could find it here : Download SSMS

Answer 4

I already uninstalled the app... only item showing is a German version of an Install.... OLE DB-Anbieter für Microsoft Analysis Services

The issue is that I cannot find the uninstallation location for this; it is not available in add remove programs nor in any folder location in my file system

Answer 5

Hi,

I happened to meet similar issue when I am setting up a new environment. And I fix it by uninstall the OLE DB Provider in the Control Panel - uninstall an APP.

Where did you find the german version Provider ? If you could not uninstall it in the control panel, it may be caused by an incorrect install.
You could try the tool and method mentioned in this Restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update

You could also try manually installing AS OLE DB provider from https://www.microsoft.com/en-us/download/details.aspx?id=55992