Enforce SQL Server NAtive Client 11.0 while using SQLCMD

1

SQLCMD is by default using SQL Server Native Client 10.0 which is throwing below eror

T:\mno\pqr>sqlcmd -S 192.168.29.3 -U abc -P def -d ghi -i "jkl.sql"
HResult 0x15, Level 16, State 1
Encryption not supported on the client.
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Client unable to establish connection.
HResult 0x80090331, Level 16, State 1
SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm.

Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or     instance-specific error has occurred while establishing a connection to SQL     Server. 
Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. 
For more information see SQL Server Books Online..

I need to reinforce SQL Server Native client 11.0 which fixes this issue (tried and tested via SSIS) but cant find the procedure. Please help

sql-server
sqlcmd
asked on Stack Overflow Oct 19, 2018 by Shishir Kumar • edited Oct 19, 2018 by jarlh

1 Answer

0

Try this folder: C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn

It works on mine:

enter image description here

answered on Stack Overflow Oct 19, 2018 by Birel

User contributions licensed under CC BY-SA 3.0