5: ServerConfig_Install7Zip - DavidRueter/SQLVer GitHub Wiki

If 7-Zip is not installed on the SQL Server you can either download and install the normal 7-Zip (that provides a user interface) from https://www.7-zip.org/ The installation should put the 7z.exe file in the default folder of C:\Program Files\7-Zip\7z.exe (which is the hard-coded fallback location).

Or, you can install the command line version into C:\SQLVer\Tools and then set the path in SQL.

In the PowerShell window paste the following and press Enter:

cd \SQLVer\Tools
.\nuget install 7-Zip.CommandLine

Then look at the C:\SQLVer\Tools folder and take note of the full path to the 7za.exe file, and finally execute the following SQL command (making sure that the path in this statement matches your actual folder name:

EXEC sqlver.spStoreSecureValue 'Path_7Zip', 'C:\SQLVer\Tools\7-Zip.CommandLine.18.1.0\tools\7za.exe'

7-Zip is used to unzip downloaded NPMJS packages and Geonames location data files.