- 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.
06-14-2023 04:46 AM
1. The connection to the MS SQL Database version 18 cannot be established with following error: Login to MS-SQL Server failed.
SSMS 18 client is installed in PSM server.
I downloaded the connector from the website below and uploaded the new MSSQLManagementStudioDatabaseAuthenticationDispatcher to the folder C:\Program Files (x86)\CyberArk\PSM\Components.
https://community.cyberark.com/mplace/s/#a352J000000pQWkQAM-a392J000001h4KeQAI
Updated PSMConfigureAppLocker.xml with client and dispatcher details.
====================================
<!-- SQL Server Management Studio 2018 processes -->
<Application Name="SSMS2018" Type="Exe" Path="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" Method="Publisher" />
====================================
<!-- PSM Components -->
<Application Name="MSSQLManagementStudioDatabaseAuthenticationDispatcher" Type="Exe" SessionType="*" Path="D:\Program Files (x86)\Cyberark\PSM\Components\MSSQLManagementStudioDatabaseAuthenticationDispatcher.exe" Method="Hash" />
====================================
<Libraries Name="vsdebugui" Type="Dll" Path="C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\Packages\Debugger\1033\vsdebugui.dll" Method="Path" />
====================================
Also, Updated Component settings in PVWA
Target Settings -> Client Specific
WindowLoadTimeout: 500
ClientInstallationPath: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe
The MSSQL Studio itself opens, and an error message in the screenshot above appears.
The login and credentials are correct. When I manually launch SSMS on the PSM Server and connect, everything works fine.
2. Additionally, how can I connect using a Domain account? Do I need to utilize Windows Authentication?
06-19-2023 08:17 PM
Is there an answer to the error above?
06-19-2023 09:22 PM
Hi @Abdulla Ydyrys ,
Can it auto fill credential or not ?
If you want to login with domain credential , you need to follow this link
https://docs.cyberark.com/Product-Doc/OnlineHelp/PAS/Latest/en/Content/PASIMP/PSM_SSMS_win.htm
06-19-2023 09:30 PM
Yes, it can automatically fill in the credentials, so I hide the credentials with a blue mark.
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!

