<?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: Managing MS SQL Service Accounts used by EPM in Endpoint Privilege Manager (EPM) Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301357#M243</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You could maybe do these restarts automatically with CyberArk PAM by adding the corresponding "usages".&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Kind regards,&lt;/P&gt;&lt;P&gt;Jelle&lt;/P&gt;</description>
    <pubDate>Tue, 18 Sep 2018 07:47:31 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2018-09-18T07:47:31Z</dc:date>
    <item>
      <title>Managing MS SQL Service Accounts used by EPM</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301353#M239</link>
      <description>&lt;P&gt;Does CyberArk support managing the SQL service account used by EPM.If CyberArk manages SQL Service Account,how does EPM communicate with the Vault for retrieving password.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Does it require AIM agent to support this use case or CyberArk has any Out of the Box capbility.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in Advance.&lt;/P&gt;</description>
      <pubDate>Mon, 17 Sep 2018 04:28:05 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301353#M239</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2018-09-17T04:28:05Z</dc:date>
    </item>
    <item>
      <title>Re: Managing MS SQL Service Accounts used by EPM</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301354#M240</link>
      <description>&lt;P&gt;I do not think it is supported out of box, but you could add a custom Usage to the SQL service account in PAS. This custom Usage would start a custom script on the EPM server every time the password is changed. The content of the script would spawn VFReconfig.exe pwd=NewPassword to update the EPM config.&lt;/P&gt;</description>
      <pubDate>Mon, 17 Sep 2018 15:04:11 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301354#M240</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2018-09-17T15:04:11Z</dc:date>
    </item>
    <item>
      <title>Re: Managing MS SQL Service Accounts used by EPM</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301355#M241</link>
      <description>&lt;P&gt;This is what we got as answer about managing the SQL Service account:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Well, its not officially supported but please find below how to rotate the password (still as a draft) &lt;/P&gt;&lt;P&gt;This is how the password should be change manually and a few points that needed to be running&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;How to Reset EPM Service Account and Application Pool Credentials?&lt;/P&gt;&lt;P&gt;Solution Details	&lt;/P&gt;&lt;P&gt;2. How to reset the EPM service account password? &lt;/P&gt;&lt;P&gt;This process changes depending on how the EPM connection to SQL was configured during the Server Installation. See attached SQLConnectionOptions.PNG &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Option B. (Its the second one listed but much easier so I'm writing it first). &amp;lt;--- not relevant cause we are using two servers for one&lt;/P&gt;&lt;P&gt;- Connect to SQL using Windows Authentication with Local System account (for local MS SQL only) &lt;/P&gt;&lt;P&gt;Here the Local System Account is being used so no change is needed. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Option A. &lt;/P&gt;&lt;P&gt;- Connect to SQL using Windows Authentication using the Username and Password below &lt;/P&gt;&lt;P&gt;If this option is chosen the Username and Password provided here are AD credentials, the IIS Application Pools will automatically be configured to run under this Account. The local EPM services (VfBackgroundWorker and VfWatchDogManager5) are installed as Local System and configured to impersonate the Application Pool user on Service Start. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;*This means that the process of changing the password is simply the process of changing the IIS Application Pool Identity password. &lt;/P&gt;&lt;P&gt;IIS &amp;gt; [Server Name] &amp;gt; Application Pools &amp;gt; [Select EPM Application Pool] - right click &amp;gt; Advanced Settings &amp;gt; Identify &amp;gt; Click-to-edit the user &amp;gt; Custom Account Set &amp;gt; Add new/changed user credentials &amp;gt; Okay/Okay/Okay &lt;/P&gt;&lt;P&gt;*Afterwards - Repeat the change for all application pools &amp;gt; Restart App Pools/IIS &lt;/P&gt;&lt;P&gt;* RESTART EPM services so they re-impersonate with the New credentials. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Option C. &lt;/P&gt;&lt;P&gt;- Connect to SQL using SQL Server authentication using the Username and Password below &lt;/P&gt;&lt;P&gt;If the Username and Password provided here are SQL credentials, the values will be encrypted and stored securely for usage by the CyberArk Endpoint Privilege Manager Server IIS components. The services are set as Local System and then use these credential files. THIS IS THE ONLY scenario where the VFReconfig.exe tool may need to be used. The VFReconfig tool unencrypts, updates, and then reencrypts this information. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Final Note - For all options - the reporting services user must be reset manually via the CyberArk EPM Connecction Points page of the EPM Manager (vfadmin.aspx) page. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can find more information about VFReconfig.exe tool in our EPM guides.&lt;/P&gt;</description>
      <pubDate>Mon, 17 Sep 2018 15:16:58 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301355#M241</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2018-09-17T15:16:58Z</dc:date>
    </item>
    <item>
      <title>Re: Managing MS SQL Service Accounts used by EPM</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301356#M242</link>
      <description>&lt;P&gt;@Jelle Verreth​&amp;nbsp;Thanks for the response,Overall it looks like these options doesnt involve CPM to manage and rotate the passwords.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Option A is more applicable to our deployment,Just to make sure I understood correctly,After the AD credentials are rotated through CyberArk or any other alternate method,we should go back to the EPM Webserver and perform the manual steps suggested under Option A.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 18 Sep 2018 02:05:37 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301356#M242</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2018-09-18T02:05:37Z</dc:date>
    </item>
    <item>
      <title>Re: Managing MS SQL Service Accounts used by EPM</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301357#M243</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You could maybe do these restarts automatically with CyberArk PAM by adding the corresponding "usages".&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Kind regards,&lt;/P&gt;&lt;P&gt;Jelle&lt;/P&gt;</description>
      <pubDate>Tue, 18 Sep 2018 07:47:31 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301357#M243</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2018-09-18T07:47:31Z</dc:date>
    </item>
    <item>
      <title>Re: Managing MS SQL Service Accounts used by EPM</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301358#M244</link>
      <description>&lt;P&gt;@Jelle Verreth​&amp;nbsp;Thanks,So this way we can manage the SQL ServiceAccount through cyberark and associate a WIndows Application Pool with restart.&lt;/P&gt;&lt;P&gt;I need to try this out,but the only concern,is whether the SQL AD credentials are only refrences under app pools or are there any other places EPM has hardcoded the SQL service account.Also,EPM service needs a restart after password change,but EPM service will be running under a different local system account.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks again I can try this out,but just want to make sure,my understanding is right.&lt;/P&gt;</description>
      <pubDate>Wed, 19 Sep 2018 02:08:40 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301358#M244</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2018-09-19T02:08:40Z</dc:date>
    </item>
    <item>
      <title>Re: Managing MS SQL Service Accounts used by EPM</title>
      <link>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301359#M245</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;With adding usages you can do all the actions that you requested.&lt;/P&gt;&lt;P&gt;It supports the following Windows Applications: &lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Service accounts including SQL server service accounts in cluster&lt;/LI&gt;&lt;LI&gt;Scheduled Tasks&lt;/LI&gt;&lt;LI&gt;IIS Application Pools&lt;/LI&gt;&lt;LI&gt;COM+&lt;/LI&gt;&lt;LI&gt;IIS Anonymous Access&lt;/LI&gt;&lt;LI&gt;Cluster Service&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;So what you do is add all the usages (one of those types) and those will then the password will also be changed on those locations. You can maybe test it first with a new account and a test scheduled task, to see how it works.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;What you need to find out is indeed all the locations where the password needs to be changed.  And if you have a test environment that's then the place to test it.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Kind regards,&lt;/P&gt;&lt;P&gt;Jelle&lt;/P&gt;</description>
      <pubDate>Wed, 19 Sep 2018 08:12:07 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/endpoint-privilege-manager-epm/managing-ms-sql-service-accounts-used-by-epm/m-p/1301359#M245</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2018-09-19T08:12:07Z</dc:date>
    </item>
  </channel>
</rss>

