- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
07-29-2024 07:15 AM
SQL Server Management Studio enabled "encryption" as part of the connection settings (Mandatory Default) (In previous versions it did not exist). Any idea how to enable a connection component for Management Studio version 20 (windows autentication)? Is version 20 already supported by CyberArk?
06-27-2025 10:30 AM
Hi @Dercel Gonzalez ,
You can add a parameter in the relevant connection component to set Encryption as Optional.
In the relevant connection component, under the 'Client Specific', add a parameter as 'Encryption' and set the Value to 'Optional'
refer this for more info: https://docs.cyberark.com/pam-self-hosted/latest/en/content/pasimp/psm_ssms.htm#ConnectionComponentsettingsinPVWA
Furthermore, SSMS v20 is supported by Cyberark.
07-29-2024 02:50 PM
Hi @Dercel Gonzalez
Please refer to the following KB for configuring PSM Connector for SQL Server Management Studio.
For supportability for v20, please check on the Marketplace or raise a Support case.
Hope it helps !
07-31-2024 03:37 PM
This kb does not specify any configuration that allows changing the "encryption" option that Microsoft incorporated in the new versions of SQL Management studio version 20.
Thanks
07-31-2024 09:24 PM
Hi @Dercel Gonzalez
Can you please clarify, when Encryption is set to Mandatory, does the PSM connection works fine or having issue when you setup using above KB?
11-20-2024 02:20 AM
Hello @4EverNewBie, did you solve this adding the parameter Encrytion?
i am having the same problem.
Thanks
01-28-2025 11:29 PM
Is there a solution without creating a new connection component?
What is the Encryption parameter all about, can it be added and does it solve the problem?
06-27-2025 10:30 AM
Hi @Dercel Gonzalez ,
You can add a parameter in the relevant connection component to set Encryption as Optional.
In the relevant connection component, under the 'Client Specific', add a parameter as 'Encryption' and set the Value to 'Optional'
refer this for more info: https://docs.cyberark.com/pam-self-hosted/latest/en/content/pasimp/psm_ssms.htm#ConnectionComponentsettingsinPVWA
Furthermore, SSMS v20 is supported by Cyberark.
07-06-2025 02:12 AM
Thank you very much, Uraz.
When I made this post (July 29, 2024), Cyberark did not yet have official support for SSM version 20. In April 2025, an official connector supporting SSM 20.2 was released.
By clicking on the following marketplace link, the connector is now available:
https://community.cyberark.com/marketplace/s/#a35Ht000001pZnCIAU-a39Ht000003RCNfIAO
If no certificate configuration exists between the PSM and the database server:
encryption = optional
TrustServerCert = Yes
07-06-2025 02:16 AM
The best solution is to download the available connector that already supports SSMS 20.2:
https://community.cyberark.com/marketplace/s/#a35Ht000001pZnCIAU-a39Ht000003RCNfIAO
encryption = optional
TrustServerCert = Yes
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!

