<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Anyone Successfully Automate SQL Service Account Rotation in Network Security Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421033#M941</link>
    <description>@Daniel Schiada - Wanted to let you know that I did hear back from CyberArk: These integrations are set up to be forward compatible, so it should work as expected on 12.1+. Its just a matter of updating the documentation.</description>
    <pubDate>Wed, 17 May 2023 14:03:19 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2023-05-17T14:03:19Z</dc:date>
    <item>
      <title>Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421027#M935</link>
      <description>&lt;P&gt;Hi, Im curious if anyone in the community has successfully been able to rotate the SQL service account credential for Venafi? We run into availability issues when we have to manually bring down all Venafi servers in the cluster to re-store connection to the database after our 90 day password rotation policy kicks in.From my experience, the tppconfiguration utility requires administrative rights on the server but doesnt behave properly when invoked remotely (even as an admin). Additionally, the commands can be executed with the return code showing successful when in fact, it fails to change the credential. The return message does not indicate any sort of failure. Any thoughts on what has worked? We plan on getting up to support gMSA (23.1.0) which will resolve the issue but curious about others experience since we still have to tackle the LDAP service account credential rotation. Thanks!Dan. &lt;/P&gt;</description>
      <pubDate>Mon, 15 May 2023 14:17:07 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421027#M935</guid>
      <dc:creator>daniel.schiada</dc:creator>
      <dc:date>2023-05-15T14:17:07Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421028#M936</link>
      <description>Hi @Daniel Schiada  - One solution that Ive seen customers implement is Automated Credential Rotation using CyberArk. Of course, that does mean theres a dependency and youd need to be using CyberArk in your environment for this solution specifically. That said, the integration does utilize the tppconfiguration utility on a specific remote Venafi server, so it does mean its possible to successfully invoke it remotely.</description>
      <pubDate>Mon, 15 May 2023 14:17:08 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421028#M936</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2023-05-15T14:17:08Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421029#M937</link>
      <description>We rotate without downtime by using 2 sets of SQL accounts. Fully automatic? No, mostly out ofparanoia. EX: When the (A) set of accounts needs a password rotation; TppConfiguration.exe is used to cascade oneVED server at at time flippingto the (B) accounts. After all the VED servers are running on the (B) accounts we rotate the (A) accounts passwords.</description>
      <pubDate>Tue, 16 May 2023 11:14:00 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421029#M937</guid>
      <dc:creator>Sherman_Becraft</dc:creator>
      <dc:date>2023-05-16T11:14:00Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421030#M938</link>
      <description>Hi @Daniel Schiada  - One solution that Ive seen customers implement is Automated Credential Rotation using CyberArk. Of course, that does mean theres a dependency and youd need to be using CyberArk in your environment for this solution specifically. That said, the integration does utilize the tppconfiguration utility on a specific remote Venafi server, so it does mean its possible to successfully invoke it remotely. Hi @Paul Cleary , appreciate the comment. I glanced at this plugin through CyberArk and it states that it only works with CyberArk 10.x and 11.x but doesnt say anything about 12.x. It also appears to have been tested withan older version of TLS Protect. Can you comment whether or not this information is accurate and up to date? @Sherman Becraft - are you running TPPConfiguration locally or remote? The issues Ive run into only occur when we are attempting to execute the configuration utility via a remote automation. If you have this working remotely, Id be interested in how you were able to get around the admin requirement (via a wrapper, etc.) since the configuration utility doesnt behave properly unless you execute it locally.</description>
      <pubDate>Tue, 16 May 2023 12:03:41 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421030#M938</guid>
      <dc:creator>daniel.schiada</dc:creator>
      <dc:date>2023-05-16T12:03:41Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421031#M939</link>
      <description>TPPConfigurationlocally BUTTPPConfiguration is/was not working as documented. This issue is clamed fixed in 20.4</description>
      <pubDate>Tue, 16 May 2023 12:23:27 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421031#M939</guid>
      <dc:creator>Sherman_Becraft</dc:creator>
      <dc:date>2023-05-16T12:23:27Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421032#M940</link>
      <description>Hi @Daniel Schiada  - One solution that Ive seen customers implement is Automated Credential Rotation using CyberArk. Of course, that does mean theres a dependency and youd need to be using CyberArk in your environment for this solution specifically. That said, the integration does utilize the tppconfiguration utility on a specific remote Venafi server, so it does mean its possible to successfully invoke it remotely. Hi @Paul Cleary , appreciate the comment. I glanced at this plugin through CyberArk and it states that it only works with CyberArk 10.x and 11.x but doesnt say anything about 12.x. It also appears to have been tested withan older version of TLS Protect. Can you comment whether or not this information is accurate and up to date?  @Daniel Schiada - The development was done on an older - though still supported - version of Venafi, but there wont have been any changes to the interaction/usage of the tppconfiguration utility. As for CyberArk v12.x support, I am not sure. Is that something you could ask your CyberArk account team to look into? Unfortunately, I dont have access to the CyberArk download portal, so Ive reached out to my CyberArk partnership contact for a response as well.</description>
      <pubDate>Tue, 16 May 2023 14:03:30 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421032#M940</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2023-05-16T14:03:30Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421033#M941</link>
      <description>@Daniel Schiada - Wanted to let you know that I did hear back from CyberArk: These integrations are set up to be forward compatible, so it should work as expected on 12.1+. Its just a matter of updating the documentation.</description>
      <pubDate>Wed, 17 May 2023 14:03:19 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421033#M941</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2023-05-17T14:03:19Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421034#M942</link>
      <description>@Daniel Schiada - Wanted to let you know that I did hear back from CyberArk: These integrations are set up to be forward compatible, so it should work as expected on 12.1+. Its just a matter of updating the documentation. Great, thanks for checking @Paul Cleary . Do you mind having your CyberArk contact update the document?  TPPConfigurationlocally BUTTPPConfiguration is/was not working as documented. This issue is clamed fixed in 20.4  @Sherman Becraft , Ive confirmed that this issue (running this remote)occurs all the way up to 22.4 releases. I have yet to test on 23.1.0but Ill test soon and it would be moot with gMSA support. Thanks for the confirmation.</description>
      <pubDate>Thu, 18 May 2023 18:39:37 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421034#M942</guid>
      <dc:creator>daniel.schiada</dc:creator>
      <dc:date>2023-05-18T18:39:37Z</dc:date>
    </item>
    <item>
      <title>Re: Anyone Successfully Automate SQL Service Account Rotation</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421035#M943</link>
      <description>UPDATE: we moved over to gMSA and its been a real blessing! No issues since we migrated to using the functionality for the database. A request to @Paul Cleary andVenafi Product team. Please expand gMSA support for Identity connections like Active Directoryand if possible, extend to provisioning credentials. Usage of gMSA significantly reduces the overhead for password rotations and improves availabity/stability of the system.</description>
      <pubDate>Mon, 11 Sep 2023 07:16:50 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/anyone-successfully-automate-sql-service-account-rotation/m-p/1421035#M943</guid>
      <dc:creator>daniel.schiada</dc:creator>
      <dc:date>2023-09-11T07:16:50Z</dc:date>
    </item>
  </channel>
</rss>

