I have been using shortcuts for connections in SQL Server Management Studio for several years, but after installing Windows Server 2022 and Management Studio 20, I need to enable the option "trust certificate".
Initially the shortcut throws an error message:
A connection was successfully established with the server, but then an error occurred during the login process - The certificate chain was issued by an authority that is not trusted
But when I enable the trusted connection it is successful.
But the question now is: how to do that in the command line ? In a connection string one would use "Trusted_Connection=True" but how to do that in a SSMS shortcut....any thoughts about that ? I am using the -S and -E parameters but there is no command line parameter for using trusted connections.
PS: I tried using command line parameters for SSMS.exe but not successfully....