core docker

core docker

  • NA
  • 15
  • 1.9k

Azure SQL server connection error from docker containerized

Feb 19 2020 3:27 AM
When i try to execute the db query from my asp.net core 3.1 (running under windows docker container) am getting the error as
 
The instance of SQL Server you attempted to connect to requires encryption but this machine does not support it.
 
same is working fine when running in IIExpress
 
i have tried different connection string format
 
Server=tcp:xxxxxxx.windows.net,1433;Initial Catalog=xxxxx;Persist Security Info=False;User ID=xxxxx;Password=xxx;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30; Server=tcp:xxxxxxx.windows.net,1433;Initial Catalog=xxxxx;Persist Security Info=False;User ID=xxxxx;Password=xxx;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30; Server=tcp:xxxxxxx.windows.net,1433;Initial Catalog=xxxxx;Persist Security Info=False;User ID=xxxxx;Password=xxx;Connection Timeout=30; Server=tcp:xxxxxxx.windows.net;Initial Catalog=xxxxx;Persist Security Info=False;User ID=xxxxx;Password=xxx;Connection Timeout=30; Server=<ipaddress>,1433;Initial Catalog=xxxxx;Persist Security Info=False;User ID=xxxxx;Password=xxx;Connection Timeout=30;
 
but nothing is worked.

Answers (1)