mssql-cli: mssql-cli broken on latest Windows update--'The system cannot find the file specified.'

I just connected to a server successful with some specific port:

mssql-cli -S server_name,port -U user -P password

But when I try to launch some query, I get the next message:

XXX> select 4+4;
Time: 0.451s
The system cannot find the file specified.

mssql-cli version: 0.18.1

About this issue

Original URL
State: closed
Created 4 years ago
Reactions: 3
Comments: 38

Most upvoted comments

thanks @ellbosch for the quick response. it works great !! which will be the right way to update ?

Alse the installation guide link from the doc is broken https://docs.microsoft.com/en-us/sql/tools/mssql-cli?view=sql-server-ver15

jvillegas74 on Mar 22, 2020

@ellbosch Please share here or by email when the fix is available. looking forward to talk and demo about mssql-cli in my next presentation

jvillegas74 on Mar 20, 2020

I can add that I just installed on a new Win 2016 Server (Azure VM) and got the same error connecting to localhost and remote server

jvillegas74 on Mar 20, 2020

We use Windows 2016 ami provided by AWS. And 0.18.1 doesn’t work with ami released after 11th Feb. So this has to be a windows update thing. @ellbosch

altafub on Mar 20, 2020

Is not the day today ! . this is after installing 0.15.0

jvillegas74 on Mar 19, 2020

yes. I can connect to my localhost running SQL 2019 using SQLCMD, ADS and SSMS with no problem

jvillegas74 on Mar 18, 2020

here

jvillegas74 on Mar 18, 2020

I have tried with 0.18.1 (latest) and 0.18.0 as well as 0.17.0 . All of them same output

Anyway here is the output

Installing collected packages: mssql-cli Attempting uninstall: mssql-cli Found existing installation: mssql-cli 0.17.0 Uninstalling mssql-cli-0.17.0: Successfully uninstalled mssql-cli-0.17.0 Successfully installed mssql-cli-0.18.0

C:\WINDOWS\system32>mssql-cli --version Version: 0.18.0

jvillegas74 on Mar 18, 2020