January 29, 2024 at 5:36 pm
version: 12.0.2000.8 NT
i'm able to connect to the server via SSMS.
my sqlcmd was working in WIN10. now my machine was upgrade to WIN11, error below:
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SSL Provider: An existing connection was forcibly closed by the remote host.
.Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Client unable to establish connection.
on server event view - system logs:
A fatal error occurred while creating a TLS client credential. The internal error state is 10011.
source: Schannel
EventID: 36871
adding TLS 1.2 and 1.3 client/server on server didn't help.
any idea what could be done to fix this?
this is a work computer so i have limited permissions
January 30, 2024 at 1:30 pm
You've updated windows, have you updated SSMS and the underlying tools? If not, start there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply