When I configure a encrypted connection to SQL Server using Management Studio and add the connection string <code>TrustServerCertificate=True</code>, this setting will not be saved so I need to enter it every time I connect anew. Any way to save this setting ? Thanks !

Unfortunately, this seems to be a known SSMS issue with no known workarounds according to Microsoft Connect. Maybe a Windows macro (e.g. using AutoHotkey) would be a reasonable workaround for you.

SQL Server Management Studio - save encrypted connection string

Tags:

sql-server

ssms

When I configure a encrypted connection to SQL Server using Management Studio and add the connection string TrustServerCertificate=True, this setting will not be saved so I need to enter it every time I connect anew.

Any way to save this setting ? Thanks !