The connection to the MS SQL Database version 18 cannot be established

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

The connection to the MS SQL Database version 18 cannot be established

L2 Linker

1. The connection to the MS SQL Database version 18 cannot be established with following error: Login to MS-SQL Server failed.

 

068Ht00000QVYZuIAP.jpgSSMS 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?

 

 

3 REPLIES 3

L2 Linker

Is there an answer to the error above?

L3 Networker

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

Yes, it can automatically fill in the credentials, so I hide the credentials with a blue mark.

  • 1068 Views
  • 3 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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!