Microsoft Command Line Utilities 14 for SQL Server Silent Install (How-To Guide)

The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of the Microsoft Command Line Utilities 14 for SQL Server from the command line using the MSI installer.

How to Install Microsoft Command Line Utilities 14 for SQL Server Silently

Microsoft Command Line Utilities 14 for SQL Server Silent Install (MSI) on 32-bit Systems

  1. Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=53591
  2. Click Download
  3. Select x86\MsSqlCmdLnUtils.msi
  4. Click Next
  5. Download the MsSqlCmdLnUtils.msi to a folder created at (C:\Downloads\x86)
  6. Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=53339
  7. Click Download
  8. Select x86\msodbcsql.msi
  9. Click Next
  10. Download the msodbcsql.msi to a folder created at (C:\Downloads\x86)
  11. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  12. Navigate to the C:\Downloads\x86 folder
  13. Enter the following commands:
MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn
MsiExec.exe /i MsSqlCmdLnUtils.msi IACCEPTMSSQLCMDLNUTILSLICENSETERMS=YES /qn

After a few moments you will find Microsoft Command Line Utilities 14 for SQL Server entries in the Installation Directory and Programs and Features in the Control Panel.

Software Title:Microsoft Command Line Utilities 14 for SQL Server
Vendor:Microsoft Corporation
Version:14.0
Architecture:32-bit
Installer Type:MSI
Silent Install Switch (Step1)MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn
Silent Install Switch (Step2)MsiExec.exe /i MsSqlCmdLnUtils.msi IACCEPTMSSQLCMDLNUTILSLICENSETERMS=YES /qn
Silent Uninstall Switch:MsiExec.exe /x {F8162E57-8672-4798-8F4F-0A79D3E44247} /qn
Repair Command:MsiExec.exe /fa {F8162E57-8672-4798-8F4F-0A79D3E44247} /qn
Download Link:https://www.microsoft.com/en-us/download/details.aspx?id=53591
PowerShell Script:https://silentinstallhq.com/microsoft-command-line-utilities-14-for-sql-server-install-and-uninstall-powershell/
Detection Script:https://silentinstallhq.com/create-a-custom-detection-script-for-microsoft-command-line-utilities-for-sql-server-powershell/

Microsoft Command Line Utilities 14 for SQL Server Silent Install (MSI) on 64-bit Systems

  1. Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=53591
  2. Click Download
  3. Select x64\MsSqlCmdLnUtils.msi
  4. Click Next
  5. Download the MsSqlCmdLnUtils.msi to a folder created at (C:\Downloads\x64)
  6. Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=53339
  7. Click Download
  8. Select x64\msodbcsql.msi
  9. Click Next
  10. Download the msodbcsql.msi to a folder created at (C:\Downloads\x64)
  11. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  12. Navigate to the C:\Downloads\x64 folder
  13. Enter the following commands:
MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn
MsiExec.exe /i MsSqlCmdLnUtils.msi IACCEPTMSSQLCMDLNUTILSLICENSETERMS=YES /qn

After a few moments you will find Microsoft Command Line Utilities 14 for SQL Server entries in the Installation Directory and Programs and Features in the Control Panel.

Software Title:Microsoft Command Line Utilities 14 for SQL Server
Vendor:Microsoft Corporation
Version:14.0
Architecture:64-bit
Installer Type:MSI
Silent Install Switch (Step1)MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn
Silent Install Switch (Step2)MsiExec.exe /i MsSqlCmdLnUtils.msi IACCEPTMSSQLCMDLNUTILSLICENSETERMS=YES /qn
Silent Uninstall Switch:MsiExec.exe /x {48C4C5F8-2821-465B-BBF6-6F45EE3B1584} /qn
Repair Command:MsiExec.exe /fa {48C4C5F8-2821-465B-BBF6-6F45EE3B1584} /qn
Download Link:https://www.microsoft.com/en-us/download/details.aspx?id=53591
PowerShell Script:https://silentinstallhq.com/microsoft-command-line-utilities-14-for-sql-server-install-and-uninstall-powershell/
Detection Script:https://silentinstallhq.com/create-a-custom-detection-script-for-microsoft-command-line-utilities-for-sql-server-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 a Microsoft Command Line Utilities 14 for SQL Server Installation Log File

The Microsoft Command Line Utilities 14 for SQL Server 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 Command Line Utilities 14 for SQL Server Silent Install with Logging on 32-bit System

MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\MSODBCSQL131x86-Install.log"
MsiExec.exe /i MsSqlCmdLnUtils.msi IACCEPTMSSQLCMDLNUTILSLICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\MsSqlCmdLnUtilsx86-Install.log"

Microsoft Command Line Utilities 14 for SQL Server Silent Install with Logging on 64-bit System

MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\MSODBCSQL131x64-Install.log"
MsiExec.exe /i MsSqlCmdLnUtils.msi IACCEPTMSSQLCMDLNUTILSLICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\MsSqlCmdLnUtilsx64-Install.log"

How to Uninstall Microsoft Command Line Utilities 14 for SQL Server Silently

Check out the following posts for a scripted solution:

Microsoft Command Line Utilities 14 for SQL Server Install and Uninstall (PowerShell)
Microsoft Command Line Utilities 14 for SQL Server Silent Uninstall (PowerShell)
  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter one of the following commands:

Microsoft Command Line Utilities 14 for SQL Server Silent Uninstall on 32-bit Systems

MsiExec.exe /x {F8162E57-8672-4798-8F4F-0A79D3E44247} /qn

Microsoft Command Line Utilities 14 for SQL Server Silent Uninstall on 64-bit Systems

MsiExec.exe /x {48C4C5F8-2821-465B-BBF6-6F45EE3B1584} /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.

Jason Bergner

I am an accomplished Software Engineer at Patch My PC, leveraging more than 18 years of hands-on experience in Configuration Manager administration and application packaging. I am driven by a genuine passion for solving complex problems and consistently strive to discover innovative and effective solutions. Sharing my extensive knowledge of application deployments is a true joy for me, and I am honored to contribute to the community here at Silent Install HQ.

Recent Posts