SSMS installation fails with ODB.MSI failure

Perera, Priyantha 21 Reputation points
2021-02-08T18:30:21.387+00:00

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'

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,871 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
{count} votes

Accepted answer
  1. Polley, Stephan 76 Reputation points
    2021-02-19T20:25:05.467+00:00
    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.
    0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-10T06:31:38.703+00:00

    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


  2. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-15T09:02:38.623+00:00

    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

    0 comments No comments

  3. Perera, Priyantha 21 Reputation points
    2021-02-15T14:04:51.383+00:00

    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

    0 comments No comments

  4. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-16T07:07:31.707+00:00

    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