<?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 Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ? in PAM Self-Hosted Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334197#M30328</link>
    <description>&lt;P&gt;&lt;B&gt;ReconcileIsWinAccount=Yes&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;ReconcileCommand= &lt;/B&gt;sp_password @new='%NEWPASSWORD%', @loginame='%USER%'&lt;/P&gt;&lt;P&gt;--------------Debug logs--------------&lt;/P&gt;&lt;P&gt;Logon with reconcile account succeeded&lt;/P&gt;&lt;P&gt;Reconciling with statement sp_password @new="%NEWPASSWORD%", @loginame="%USER%"&lt;/P&gt;&lt;P&gt;ExecutionStringTemplate: [sp_password @new="%NEWPASSWORD%", @loginame="%USER%"] Length: [52]&lt;/P&gt;&lt;P&gt;'newpassword' is not a valid parameter name. Please update the command : 'sp_password @new="%newpassword%", @loginame="%user%"' so that it contains only valid parameters.&lt;/P&gt;&lt;P&gt;Failed to serialize string sp_password @new="%NEWPASSWORD%", @loginame="%USER%"&lt;/P&gt;&lt;P&gt;Failed to reconcile with statement sp_password @new="%NEWPASSWORD%", @loginame="%USER%"&lt;/P&gt;&lt;P&gt;Clean ups&lt;/P&gt;&lt;P&gt;Rc: 2120&lt;/P&gt;&lt;P&gt;Ending plug-in&lt;/P&gt;&lt;P&gt;------------------------------------------------------------&lt;/P&gt;&lt;P&gt;Note: strangely there is another account(different name) which is associated with same platform &amp;amp; safe which is working fine and I can reconcile it.&lt;/P&gt;</description>
    <pubDate>Mon, 10 Jun 2024 07:49:34 GMT</pubDate>
    <dc:creator>AMaharana</dc:creator>
    <dc:date>2024-06-10T07:49:34Z</dc:date>
    <item>
      <title>Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334197#M30328</link>
      <description>&lt;P&gt;&lt;B&gt;ReconcileIsWinAccount=Yes&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;B&gt;ReconcileCommand= &lt;/B&gt;sp_password @new='%NEWPASSWORD%', @loginame='%USER%'&lt;/P&gt;&lt;P&gt;--------------Debug logs--------------&lt;/P&gt;&lt;P&gt;Logon with reconcile account succeeded&lt;/P&gt;&lt;P&gt;Reconciling with statement sp_password @new="%NEWPASSWORD%", @loginame="%USER%"&lt;/P&gt;&lt;P&gt;ExecutionStringTemplate: [sp_password @new="%NEWPASSWORD%", @loginame="%USER%"] Length: [52]&lt;/P&gt;&lt;P&gt;'newpassword' is not a valid parameter name. Please update the command : 'sp_password @new="%newpassword%", @loginame="%user%"' so that it contains only valid parameters.&lt;/P&gt;&lt;P&gt;Failed to serialize string sp_password @new="%NEWPASSWORD%", @loginame="%USER%"&lt;/P&gt;&lt;P&gt;Failed to reconcile with statement sp_password @new="%NEWPASSWORD%", @loginame="%USER%"&lt;/P&gt;&lt;P&gt;Clean ups&lt;/P&gt;&lt;P&gt;Rc: 2120&lt;/P&gt;&lt;P&gt;Ending plug-in&lt;/P&gt;&lt;P&gt;------------------------------------------------------------&lt;/P&gt;&lt;P&gt;Note: strangely there is another account(different name) which is associated with same platform &amp;amp; safe which is working fine and I can reconcile it.&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 07:49:34 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334197#M30328</guid>
      <dc:creator>AMaharana</dc:creator>
      <dc:date>2024-06-10T07:49:34Z</dc:date>
    </item>
    <item>
      <title>Re: Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334198#M30329</link>
      <description>&lt;P&gt;The default plugin has restrictions over what characters can be in the password - if one is working and one isn't, verify the password doesn't contain any of them. I would expect an error like that if it did.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;CommandForbiddenCharacters='\/@".{}() -;|*&amp;gt;~!^#&amp;nbsp;&amp;nbsp;&amp;nbsp;;Characters that cannot be used in the parameters of the change/reconcile command.&lt;/P&gt;&lt;P&gt;CommandBlackList=delete,drop,exec,create,alter,rename,truncate,comment,select,insert,update,merge,call,explain,lock,grant,revoke&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;;Words that cannot be used in the change/reconcile command. Separate multiple values with a comma.&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 08:26:28 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334198#M30329</guid>
      <dc:creator>Mal</dc:creator>
      <dc:date>2024-06-10T08:26:28Z</dc:date>
    </item>
    <item>
      <title>Re: Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334199#M30330</link>
      <description>&lt;P&gt;Hi @Amit Maharana​&amp;nbsp;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There seems to be a problem with the command that is used for reconciliation. Can you check the command under the particular platform that the account is associated with --&amp;gt; Automatic Password Management --&amp;gt; Additional Policy Settings --&amp;gt; Reconcile Command. You can check the command based on your SQL Server on the CyberArk Page.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can navigate to this page and find you database server and then move to the part where the Reconciliation command is mentioned. --&amp;gt; &lt;A alt="https://docs.cyberark.com/pam-self-hosted/latest/en/Content/PASIMP/Databases.htm?tocpath=Administrator%7CComponents%7CCentral%20Policy%20Manager%7CCPM%20plugins%7CTarget%20account%20plugins%7CDatabases%7C_____0" href="https://docs.cyberark.com/pam-self-hosted/latest/en/Content/PASIMP/Databases.htm?tocpath=Administrator%7CComponents%7CCentral%20Policy%20Manager%7CCPM%20plugins%7CTarget%20account%20plugins%7CDatabases%7C_____0" target="_blank"&gt;Databases | CyberArk Docs&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 08:42:37 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334199#M30330</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2024-06-10T08:42:37Z</dc:date>
    </item>
    <item>
      <title>Re: Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334200#M30331</link>
      <description>&lt;P&gt;Hi @Amit Maharana​&amp;nbsp;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There seems to be a problem with the command that is used for reconciliation. Can you check the command under the particular platform that the account is associated with --&amp;gt; Automatic Password Management --&amp;gt; Additional Policy Settings --&amp;gt; Reconcile Command. You can check the command based on your SQL Server on the CyberArk Page.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can navigate to this page and find you database server and then move to the part where the Reconciliation command is mentioned. --&amp;gt; &lt;A alt="https://docs.cyberark.com/pam-self-hosted/latest/en/Content/PASIMP/Databases.htm?tocpath=Administrator%7CComponents%7CCentral%20Policy%20Manager%7CCPM%20plugins%7CTarget%20account%20plugins%7CDatabases%7C_____0" href="https://docs.cyberark.com/pam-self-hosted/latest/en/Content/PASIMP/Databases.htm?tocpath=Administrator%7CComponents%7CCentral%20Policy%20Manager%7CCPM%20plugins%7CTarget%20account%20plugins%7CDatabases%7C_____0" target="_blank"&gt;Databases | CyberArk Docs&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 08:42:37 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334200#M30331</guid>
      <dc:creator>A.Rathore992691</dc:creator>
      <dc:date>2024-06-10T08:42:37Z</dc:date>
    </item>
    <item>
      <title>Re: Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334201#M30332</link>
      <description>&lt;P&gt;Hi @Malcolm Murray​&amp;nbsp;,&lt;/P&gt;&lt;P&gt;Missed to mention that failing &amp;amp; succeeding accounts are all part of different account groups. But the Group Platform is unique meaning that all accounts in both groups are associated with same Group Platform.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Also, when i remove the failing account from accounts group and try to reconcile, it works.&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 09:24:14 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334201#M30332</guid>
      <dc:creator>AMaharana</dc:creator>
      <dc:date>2024-06-10T09:24:14Z</dc:date>
    </item>
    <item>
      <title>Re: Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334202#M30333</link>
      <description>&lt;P&gt;Perhaps the account group is choosing a bad password. Have you checked that? &lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 09:36:24 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334202#M30333</guid>
      <dc:creator>Mal</dc:creator>
      <dc:date>2024-06-10T09:36:24Z</dc:date>
    </item>
    <item>
      <title>Re: Failed to serialize string sp_password. SQL account reconciliation issue. Any expertise to fix this please ?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334203#M30334</link>
      <description>&lt;P&gt;Quite unlikely. Because the group platform password policy is exact same as account platform.&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 10:13:15 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/failed-to-serialize-string-sp-password-sql-account/m-p/1334203#M30334</guid>
      <dc:creator>AMaharana</dc:creator>
      <dc:date>2024-06-10T10:13:15Z</dc:date>
    </item>
  </channel>
</rss>

