Microsoft ODBC Driver 17 for SQL Server Silent Install (How-To Guide)


Microsoft ODBC Driver for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to SQL Server. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of the Microsoft ODBC Driver 17 for SQL Server from the command line using the MSI installer.

How to Install Microsoft ODBC Driver 17 for SQL Server Silently

Microsoft ODBC Driver 17 for SQL Server Silent Install (MSI) on 32-bit Systems

  1. Navigate to: https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver15#179
  2. Select Download x86 installer link
  3. Download the msodbcsql.msi to a folder created at (C:\Downloads\x86)
  4. Navigate to: https://aka.ms/vs/17/release/vc_redist.x86.exe
  5. Download the vc_redist.x86.exe to a folder created at (C:\Downloads\x86)
  6. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  7. Navigate to the C:\Downloads\x86 folder
  8. Enter the following commands:
vc_redist.x86.exe /install /quiet /norestart
MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn

After a few moments you will find Microsoft ODBC Driver 17 for SQL Server entries in the Installation Directory and Programs and Features in the Control Panel.

Software Title:Microsoft ODBC Driver 17 for SQL Server
Vendor:Microsoft Corporation
Version:17.9
Architecture:32-bit
Installer Type:MSI
Silent Install Switch (Step 1)vc_redist.x86.exe /install /quiet /norestart
Silent Install Switch (Step 2)MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn
Silent Uninstall Switch:MsiExec.exe /x {B779698E-BCFA-4735-B23F-45AA5F47B5A4} /qn
Repair Command:MsiExec.exe /fa {B779698E-BCFA-4735-B23F-45AA5F47B5A4} /qn
Download Link:https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver15
PowerShell Script:https://silentinstallhq.com/microsoft-odbc-driver-17-for-sql-server-install-and-uninstall-powershell/

Microsoft ODBC Driver 17 for SQL Server Silent Install (MSI) on 64-bit Systems

  1. Navigate to: https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver15#179
  2. Select Download x64 installer link
  3. Download the msodbcsql.msi to a folder created at (C:\Downloads\x64)
  4. Navigate to: https://aka.ms/vs/17/release/vc_redist.x64.exe
  5. Download the vc_redist.x64.exe to a folder created at (C:\Downloads\x64)
  6. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  7. Navigate to the C:\Downloads\x64 folder
  8. Enter the following commands:
vc_redist.x64.exe /install /quiet /norestart
MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn

After a few moments you will find Microsoft ODBC Driver 17 for SQL Server entries in the Installation Directory and Programs and Features in the Control Panel.

Microsoft SQL Server 2019 Express S...
Microsoft SQL Server 2019 Express Silent Install (How-To Guide)
Software Title:Microsoft ODBC Driver 17 for SQL Server
Vendor:Microsoft Corporation
Version:17.9
Architecture:64-bit
Installer Type:MSI
Silent Install Switch (Step 1)vc_redist.x64.exe /install /quiet /norestart
Silent Install Switch (Step 2)MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn
Silent Uninstall Switch:MsiExec.exe /x {BC76A645-75D3-4A9E-9DDC-1DFBC959FB67} /qn
Repair Command:MsiExec.exe /fa {BC76A645-75D3-4A9E-9DDC-1DFBC959FB67} /qn
Download Link:https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver15
PowerShell Script:https://silentinstallhq.com/microsoft-odbc-driver-17-for-sql-server-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 ODBC Driver 17 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 ODBC Driver 17 for SQL Server Silent Install with Logging on 32-bit System

vc_redist.x86.exe /install /quiet /norestart /log "%WINDIR%\Temp\VC2017x86-Install.log"
MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\MSODBCSQL17x86-Install.log"

Microsoft ODBC Driver 17 for SQL Server Silent Install with Logging on 64-bit System

vc_redist.x64.exe /install /quiet /norestart /log "%WINDIR%\Temp\VC2017x64-Install.log"
MsiExec.exe /i msodbcsql.msi IACCEPTMSODBCSQLLICENSETERMS=YES /qn /L*v "%WINDIR%\Temp\MSODBCSQL17x64-Install.log"

Include the ODBC Driver for SQL Server SDK Feature

32-bit System

vc_redist.x86.exe /install /quiet /norestart
MsiExec.exe /i msodbcsql.msi ADDLOCAL=ALL IACCEPTMSODBCSQLLICENSETERMS=YES /qn

64-bit System

vc_redist.x64.exe /install /quiet /norestart
MsiExec.exe /i msodbcsql.msi ADDLOCAL=ALL IACCEPTMSODBCSQLLICENSETERMS=YES /qn

How to Uninstall Microsoft ODBC Driver 17 for SQL Server Silently

Check out the Microsoft ODBC Driver 17 for SQL Server Install and Uninstall (PowerShell) post for a scripted solution.

  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter one of the following commands:
VersionMicrosoft ODBC Driver 17 for SQL Server Silent Uninstall String
17.10 (32-bit)MsiExec.exe /x {C36787AB-95C4-4E00-9645-E9DB459F04DE} /qn
17.10 (64-bit)MsiExec.exe /x {4FA42D7E-0446-4406-BB89-643765F9A38F} /qn
17.9 (32-bit)MsiExec.exe /x {B779698E-BCFA-4735-B23F-45AA5F47B5A4} /qn
17.9 (64-bit)MsiExec.exe /x {BC76A645-75D3-4A9E-9DDC-1DFBC959FB67} /qn
17.8 (32-bit)MsiExec.exe /x {2496C3F0-D156-48F1-9514-E488EE19C0F7} /qn
17.8 (64-bit)MsiExec.exe /x {7453C0F5-03D5-4412-BB8F-360574BE29AF} /qn
17.7.2 (32-bit)MsiExec.exe /x {6B841706-4DE6-48B7-B420-8242D9E7A503} /qn
17.7.2 (64-bit)MsiExec.exe /x {853997DA-6FCB-4FB9-918E-E0FF881FAF65} /qn
17.7 (32-bit)MsiExec.exe /x {DE420266-132A-4521-8247-B93C84B04AC3} /qn
17.7 (64-bit)MsiExec.exe /x {014E8F90-CED3-41BD-ACF3-D6EA3EAD4560} /qn
17.6 (32-bit)MsiExec.exe /x {3755F5CE-EFD4-4671-9C67-B0359D595379} /qn
17.6 (64-bit)MsiExec.exe /x {DBCD7798-30AE-474B-A733-717996DCCA41} /qn
17.5.2 (32-bit)MsiExec.exe /x {61CFB794-D1FA-4C61-8B11-FDB153D1C47E} /qn
17.5.2 (64-bit)MsiExec.exe /x {12DC69AF-787B-4D76-B69D-2716DACA79FB} /qn
17.5 (32-bit)MsiExec.exe /x {9227BFE7-F9AB-4AF4-802F-F312DD1A4E02} /qn
17.5 (64-bit)MsiExec.exe /x {E36FFC78-D25E-4962-872B-9CE0E50E62CD} /qn
17.4.2 (32-bit)MsiExec.exe /x {A267F78D-3999-4EBD-9F63-9CADAF07E64A} /qn
17.4.2 (64-bit)MsiExec.exe /x {50BD7EC6-A085-48F8-8664-18A8BB3E768C} /qn
17.4 (32-bit)MsiExec.exe /x {B27925A2-E6A2-4A62-8BE3-92F6974D1996} /qn
17.4 (64-bit)MsiExec.exe /x {72AFAF21-33FB-45A5-9468-A9EC07427F82} /qn
17.3 (32-bit)MsiExec.exe /x {7265E8BC-4EA4-403F-9B87-6FD9BD964D0A} /qn
17.3 (64-bit)MsiExec.exe /x {175BC9FC-C256-4EFC-9D87-4A9AF3B47A12} /qn
17.2 (32-bit)MsiExec.exe /x {D3A13CE1-E8A4-4812-90CD-2DDCA13F4CF7} /qn
17.2 (64-bit)MsiExec.exe /x {8D98AC2C-FC5C-440D-A2D3-6C9655F957D8} /qn
17.1 (32-bit)MsiExec.exe /x {C9A0CE4D-741E-4505-8D01-BBF61A27D031} /qn
17.1 (64-bit)MsiExec.exe /x {5F9345E2-76B2-4639-AD3B-DB2ABC716930} /qn
17.0 (32-bit)MsiExec.exe /x {6D03E27A-F010-4D45-B884-028E91452285} /qn
17.0 (64-bit)MsiExec.exe /x {01D74C69-4BB4-4616-9968-A7E6A6EE81B4} /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.

Recent Posts