The Microsoft Analysis Services OLE DB Provider (MSOLAP) is the native client library for Analysis Services database connections. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of the Microsoft Analysis Services OLE DB Provider (MSOLAP) from the command line using the MSI installer.
How to Install Microsoft Analysis Services OLE DB Provider (MSOLAP) Silently
Microsoft Analysis Services OLE DB Provider (MSOLAP) 32-bit Silent Install (MSI)
- Navigate to: https://go.microsoft.com/fwlink/?linkid=829575
- Download the x86_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi to a folder created at (C:\Downloads)
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Navigate to the C:\Downloads folder
- Enter the following command:
MsiExec.exe /i x86_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn - Press Enter
After a few moments you will find Microsoft Analysis Services OLE DB Provider entries in the Installation Directory and Programs and Features in the Control Panel.
| Software Title: | Microsoft Analysis Services OLE DB Provider |
| Vendor: | Microsoft Corporation |
| Architecture: | 32-bit |
| Installer Type: | MSI |
| Silent Install Switch: | MsiExec.exe /i x86_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
| Silent Uninstall Switch: | MsiExec.exe /x x86_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
| Repair Command: | MsiExec.exe /fa x86_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
| Download Link: | https://go.microsoft.com/fwlink/?linkid=829575 |
| PowerShell Script: | https://silentinstallhq.com/microsoft-analysis-services-ole-db-provider-msolap-install-and-uninstall-powershell/ |
Microsoft Analysis Services OLE DB Provider (MSOLAP) 64-bit Silent Install (MSI)
- Navigate to: https://go.microsoft.com/fwlink/?linkid=829576
- Download the x64_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi to a folder created at (C:\Downloads)
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Navigate to the C:\Downloads folder
- Enter the following command:
MsiExec.exe /i x64_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn - Press Enter
After a few moments you will find Microsoft Analysis Services OLE DB Provider entries in the Installation Directory and Programs and Features in the Control Panel.
| Software Title: | Microsoft Analysis Services OLE DB Provider |
| Vendor: | Microsoft Corporation |
| Architecture: | 64-bit |
| Installer Type: | MSI |
| Silent Install Switch: | MsiExec.exe /i x64_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
| Silent Uninstall Switch: | MsiExec.exe /x x64_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
| Repair Command: | MsiExec.exe /fa x64_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
| Download Link: | https://go.microsoft.com/fwlink/?linkid=829576 |
| PowerShell Script: | https://silentinstallhq.com/microsoft-analysis-services-ole-db-provider-msolap-install-and-uninstall-powershell/ |
The information above provides a quick overview of the software title, vendor, silent install, and silent uninstall switches. The download links provided take you directly to the vendors website. Continue reading if you are interested in additional details and configurations.
Additional Configurations
Create an Installation Log File
The Microsoft Analysis Services OLE DB Provider (MSOLAP) installer offers the option to generate a log file during installation to assist with troubleshooting should any problems arise. You can use the following commands to create a verbose log file with details about the installation.
Microsoft Analysis Services OLE DB Provider (MSOLAP) 32-bit Silent Install with Logging
MsiExec.exe /i x86_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn /L*v "%WINDIR%\Temp\MSOLAPx86-Install.log" |
Microsoft Analysis Services OLE DB Provider (MSOLAP) 64-bit Silent Install with Logging
MsiExec.exe /i x64_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn /L*v "%WINDIR%\Temp\MSOLAPx64-Install.log" |
How to Uninstall Microsoft Analysis Services OLE DB Provider (MSOLAP) Silently
Check out the Microsoft Analysis Services OLE DB Provider (MSOLAP) Install and Uninstall (PowerShell) post for a scripted solution.
- Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
- Enter one of the following commands:
Microsoft Analysis Services OLE DB Provider (MSOLAP) 32-bit Silent Uninstall
MsiExec.exe /x x86_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
Microsoft Analysis Services OLE DB Provider (MSOLAP) 64-bit Silent Uninstall
MsiExec.exe /x x64_xx.x.xxxx.xxx_SQL_AS_OLEDB.msi /qn |
Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.