Error while connecting to Azure SQL database through PSM

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

Error while connecting to Azure SQL database through PSM

L3 Networker

Getting below error while connecting to Azure SQL database through PSM, Any idea what's going wrong here.

 

Session has been closed PSM-SSMS-Database2020 PSMSR133E [9b6c1994-0f0a-46b7-8b8b-1ccf1437b6ff] Failed to create process "C:\Program Files (x86)\CyberArk\PSM\Components\CyberArk.PSM.SSMSDatabaseAuthentication.exe". Code: 2Field_Content_versions_oct20__068Vy000011IVSWIA4.pngIn an attempt to solve the issue I, In AppLocker, I have whitelisted the path C:\Program Files (x86)\CyberArk\PSM\Components\CyberArk.PSM.SSMSDatabaseAuthentication.exe but still no success.

3 REPLIES 3

L7 Applicator

Hi @R K​

 

On each PSMs, please validate the path  C:\Program Files (x86)\CyberArk\PSM\Components\CyberArk.PSM.SSMSDatabaseAuthentication.exe against the path defined under Target Settings in PSM Connector configured on PVWA.

 

Also check that this file “CyberArk.PSM.SSMSDatabaseAuthentication.exe” actually exists on each PSMs.

 

For the testing, keep all the AppLocker rules into Audit mode and then try to test the connector.

 

In addition check that PSMConnect and PSMAdminConnect accounts have permissions on \PSM\Components folder on each PSMs.

 

 

Hope it helps !

  • path is right it's configured in Target setting as "{PSMComponentsFolder}\CyberArk.PSM.SSMSDatabaseAuthentication.exe" "{PSMComponentsFolder}"
  • file does exists in file stucture
  • Audit only mode doesn't help, still same error
  • PSMConnect and PSMAdminConnect account has Read & Execute, List Folder Contents, and Read permissions and are inline with CyberArk recommendation

L7 Applicator

Hi @R K​ 

 

Please check the Event Viewer for any errors while you try to run the connector.

 

Are you using the SSMS version ( 32 bit or 64 bit) which is supported by the database?

 

If possible, please share your connector configuration screenshot (without any sensitive information).

 

Please enable PSM debug logs and share more information.

 

 

  • 121 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!