We have an account that needs to sync both Windows and SQL. Is there a way to set/allow two platforms to be set on one account? Or what way would allow the windows services to be set as well as connecting to SQL and updating the password there. Thank you

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

We have an account that needs to sync both Windows and SQL. Is there a way to set/allow two platforms to be set on one account? Or what way would allow the windows services to be set as well as connecting to SQL and updating the password there. Thank you

L1 Bithead
1 accepted solution

Accepted Solutions

Hi Delgado,

 

Platforms are used to define how's the password to be managed, as such, you only need one platform (that is Windows platform in your case) and onboard the account to it.

 

For access, the Windows platform already comes with RDP. And you can add Connection Components to the platform (Platform Management > Manage PSM Connectors) for other access methods (such as, SSMS for SQL)

 

You can get the SSMS for Windows Account from CyberArk Marketplace

  • SQL Server Management Studio (SSMS) - Windows Accounts: https://community.cyberark.com/marketplace/s/#a35Ht000001pZnCIAU-a39Ht000003RCNfIAO

 

After that, users will be able to select the connection method on the account when they want to make connection.

 

View solution in original post

11 REPLIES 11

L7 Applicator

The usual way is to create an account group and add both accounts .

 

https://docs.cyberark.com/privilege-cloud-standard/latest/en/content/pasimp/account-groups.htm

Thank you for getting back to me!

 

I'm not sure this will work for our issue though. This is a singular account that needs to auto rotate credentials for Windows services and local SQL credentials on the box. We have the account linked to our Windows platform and works as expected, but we also need it to run the SQL connection and if we add that to the same platform, it will no longer reconcile Windows creds since its using the SQL connection command.

L3 Networker

Hi @John Delgado​ ,

 

Can I clarify, do you have one account to be managed and want to connect to both Windows and SQL? For example, the windows domain account, and it will be used for authenticating to SQL server.

 

Or they are actually 2 separated accounts that from different source?

L1 Bithead

Hello Argon,

 

It is as you say first, it is one account that needs to connect to both Windows and SQL for authentication with SCCM and its DataBase.

Hi Delgado,

 

Platforms are used to define how's the password to be managed, as such, you only need one platform (that is Windows platform in your case) and onboard the account to it.

 

For access, the Windows platform already comes with RDP. And you can add Connection Components to the platform (Platform Management > Manage PSM Connectors) for other access methods (such as, SSMS for SQL)

 

You can get the SSMS for Windows Account from CyberArk Marketplace

  • SQL Server Management Studio (SSMS) - Windows Accounts: https://community.cyberark.com/marketplace/s/#a35Ht000001pZnCIAU-a39Ht000003RCNfIAO

 

After that, users will be able to select the connection method on the account when they want to make connection.

 

Hi Argon,

 

This will work perfectly for this use case from the looks of it. Unfortunately, I am not seeing "Manage PSM Connectors" under Platform management nor anywhere else. Do we require an additional license for this to work?

 

Thank you for all your help!

Hi @John Delgado​ ,

 

You don't need additional license.

 

You can click the "3 dots" icon on the right hand side of the platform, then you will see the menu and "Manage PSM connectors" option.

 

Field_Content_versions_oct20__068Vy000019uuQ1IAI.png 

Then, you can search "sql" to see if the connection component is available. If it is not available, you can download it from my previous link and import it. And please also refer to that link for setting it up, for example, you will need to install SSMS on PSM server, configure the AppLocker, etc.

Field_Content_versions_oct20__068Vy000019ua80IAA.png

Thank you for sending the screenshots for clarification. Unfortunately, I do not have that option on my platforms. I only have the other 5 options of Edit, Duplicate, Delete, Deactivate, Export.

Have you installed at least one PSM server in this privilege cloud tenant? I believe you need that before you can see the option.

I'm going to assume we have not installed that. I'll see what I can find on that. Thank you

L4 Transporter

Hello,

In the navigation menu on the PVWA, select the gear for options then select Platform Administration which will take you to the screen needed. If you select Options, then Platform Administration you have the standard options which you refer that doesn't have the import options.

  • 1 accepted solution
  • 111 Views
  • 11 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!