Microsoft Command Line Utilities 15 for SQL Server fails to recognize pre-requisite ODBC 17
SQLCMD docs state that Command Line Utilities 15 requires ODBC 17 (https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017). However, the actual Command Line Utilities 15 installer does not recognize a previously installed ODBC 17.
Installing ODBC 13 will allow the Command Line Utilities 15 installer to complete successfully, but we end up with errors later presumably due to the Command Line Utilities 15 actually requiring OBDC 17 functionality. Installing both versions 13 and 17 seems to get around this, but obviously requires installation of both packages.
Our server for testing this is a 64 bit Windows 2008 R2 Enterprise with SP1.
- Install ODBC 17 from the downloads available here: https://www.microsoft.com/download/details.aspx?id=56567
- Install Command Line Utilities 15 from the links available here: https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
- Observe error message during Command Line Utilities installation: Setup is missing an installation prerequisite: -Microsoft ODBC Driver 17 for SQL Server. To continue, install Microsoft ODBC Driver 17 for SQL Server and then run the setup operation again
- Exit the utils installation.
- Install ODBC 13.1 from the downloads available here: https://www.microsoft.com/en-us/download/details.aspx?id=53339
- Run the Command Line Utilities 15 installer again.
- Observe success.
Februray 2020: Same for my Windows 10 workstation. Workaround still effective. Thanks!
Pierre JANDOT commented
February 2020: Same error message from Windows 10 workstation. Workaround still effective. Thanks!
Boo to MS for such sloppy job. Thanks for the workaround!
Typical Microsoft stupidity!
Ridiculous way to get it to work especially when the install message only requires ODBC 17.
[Deleted User] commented
Still very valid. Worked great for me. Thank you again.
Edward Hellyer commented
Excellent work around. Thank you for sharing.
Edward Hellyer commented
Oh Microsoft. Same installer dependency issues, different decade.
Windows 10, msodbcsql_126.96.36.199_x64.msi, MsSqlCmdLnUtils.msi
Alexey Stolyarov commented
Same issue with Windows Server 2019
Workaround from original message helped. Thanks!
Same with Windows Server 2012 R2
We too can confirm this on a Windows 10 Enterprise (Version 1709, OSBUILD 16299.309).
The workaround detailed above works and is frankly somewhat ridiculous.
same issue on my Win10
yep observe issue with
Microsoft Command Line Utilities 15 for SQL Server
The same on Server 2019.
I had this exact problem on 2016 Data Center Edition