Error: Request error: UNABLE_TO_GET_ISSUER_CERT_LOCALLY

[thekingofspain]

• MSSQL Extension Version: 1.22.1
• VSCode Version: 1.86.2
  • "http.proxyStrictSSL": false,
• OS Version: 10.0.19045 Build 19045

Steps to Reproduce:

1. Launch VS Code.
2. Open *.sql file.
3. Format Document:

OUTPUT Tab - SQLToolsService initialization:

Initializing SQL tools service for the mssql extension.
Note: mssql commands will be available after installing the service.

Platform: win32, x86_64 (Windows)

Installing SQL tools service to c:\Users\_xxx_\.vscode\extensions\ms-mssql.mssql-1.22.1\sqltoolsservice\4.10.2.1\Windows.
Downloading https://github.com/Microsoft/sqltoolsservice/releases/download/4.10.2.1/microsoft.sqltools.servicelayer-win-x64-net7.0.zip
[ERROR] Error: Request error: UNABLE_TO_GET_ISSUER_CERT_LOCALLY

Notifications

Sorry, something went wrong activating IntelliCode support for SQL. Please check the "MSSQL" and "VS IntelliCode" output windows for details.

mssql: Failed to load Sql Tools Service

[thekingofspain]

Figured out the cause of the issue, Zscaler security software. Turning off the Zscaler software allowed the the software to install.

Note: mssql commands will be available after installing the service.

Platform: win32, x86_64 (Windows)

Installing SQL tools service to c:\Users\_xxx_\.vscode\extensions\ms-mssql.mssql-1.22.1\sqltoolsservice\4.10.2.1\Windows.
Downloading https://github.com/Microsoft/sqltoolsservice/releases/download/4.10.2.1/microsoft.sqltools.servicelayer-win-x64-net7.0.zip
(76658 KB) .................... Done!
Installing ...
Done! 856 files unpacked.