10

I have a very unusual bug when trying to connect to a live Azure database via Visual Studio 2022 (17.5.0) using the following connection properties:

  • Encryption = true
  • Trust Server Certificate = true

The target database connection (read-only) is completely fine when using the Publish Database feature. However, when clicking the Edit > Advanced, Visual Studio automatically sets the Trust Server Certificate to false. The Encryption is still set to true.

I checked the same scenario using a different machine (lower VS version), but it doesn't override the connection property.

jarlh
  • 42,561
  • 8
  • 45
  • 63
abramlimpin
  • 5,027
  • 11
  • 58
  • 97
  • 1
    Just installed VS2022 (v17.5.3) and have the same problem - it's not remembering the change when I set Trust Certificate = True. This is connecting to an on-prem SQL Server, not Azure. – Mike Mar 30 '23 at 23:25
  • 3
    I ended up reverting back to using VS2019 where this works fine. – Mike Mar 31 '23 at 00:02

0 Answers0