mssql-cli is supported on Windows with:
- Windows (x86/x64) 8.1
- Windows (x86/x64) 10
- Windows Server 2012+
Python is required for installation of mssql-cli and is not installed by default on Windows. To install Python, follow these instructions:
- Open the latest Python installer package from here.
- Select Add Python [Version] to PATH option before installation. Python must be in the PATH environment variable.
- Install Python.
If Python was installed into the "Program Files" directory, you may need to open the command prompt as an administrator for the above command to succeed.
Proceed to the next section once Python is installed and in the PATH environment variable.
Note: your path to Python may be different from the listed command. For example, instead of
python
you may need to callpython3
.
mssql-cli is installed using pip
on Windows:
python -m pip install mssql-cli
Uninstall mssql-cli using pip
:
pip uninstall mssql-cli
Set two environment variables:
set http_proxy=domain\username:password@proxy_server:port
set https_proxy=domain\username:password@proxy_server:port
If the Password contains special characters like @,$,!
(e.g. password:PLACEHOLDER
) then replace the special characters by their hex code equivalents with %
prefix, as exemplified below:
@
:%40
$
:%24
!
:%21
Example: username:p%40ssword@proxy_server:port
You may attempt installation after completing these steps:
pip install mssql-cli