<?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: Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully? in PAM Self-Hosted Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315362#M15636</link>
    <description>&lt;P&gt;The default &lt;B&gt;PSM-SQLServerMgmtStudio &lt;/B&gt;connection component can connect to MSSQL Instances running on dynamic ports.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please ensure that the firewall between the PSM and the MSSQL Instance allows the PSM server to reach the DB on the required ports. This can be validated by  executing MSSQL Management Studio manually on the PSM server and attempting to connect to the MSSQL instance. If this work, the connection component should work as well.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If the SQL uses fixed ports, you can edit or duplicate another connector and modify the ClientApp to as follows:&lt;/P&gt;&lt;P&gt;"C:\[Path to ManagementStudio]\ssms.exe" -S "{Address},{Port}" -U "{UserName}" -P "{Password}"&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 22 May 2019 09:01:23 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2019-05-22T09:01:23Z</dc:date>
    <item>
      <title>Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315361#M15635</link>
      <description />
      <pubDate>Fri, 12 Apr 2019 18:30:00 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315361#M15635</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-04-12T18:30:00Z</dc:date>
    </item>
    <item>
      <title>Re: Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315362#M15636</link>
      <description>&lt;P&gt;The default &lt;B&gt;PSM-SQLServerMgmtStudio &lt;/B&gt;connection component can connect to MSSQL Instances running on dynamic ports.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please ensure that the firewall between the PSM and the MSSQL Instance allows the PSM server to reach the DB on the required ports. This can be validated by  executing MSSQL Management Studio manually on the PSM server and attempting to connect to the MSSQL instance. If this work, the connection component should work as well.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If the SQL uses fixed ports, you can edit or duplicate another connector and modify the ClientApp to as follows:&lt;/P&gt;&lt;P&gt;"C:\[Path to ManagementStudio]\ssms.exe" -S "{Address},{Port}" -U "{UserName}" -P "{Password}"&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 22 May 2019 09:01:23 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315362#M15636</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-05-22T09:01:23Z</dc:date>
    </item>
    <item>
      <title>Re: Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315363#M15637</link>
      <description>&lt;P&gt;@Josiah Winston​&amp;nbsp;&lt;/P&gt;&lt;P&gt;We are also facing the same issue, after the inbound PSM server port is open we are able to login to the MSSQL instance.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;But we are not able to login the DB directly via 'SQL Server Authentication' . Every time we need to select the Authentication as SQL server Authentication and enter the user name and password.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please advice how to login directly via SQL server authentication from PSM.&lt;/P&gt;</description>
      <pubDate>Tue, 28 May 2019 10:19:10 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315363#M15637</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-05-28T10:19:10Z</dc:date>
    </item>
    <item>
      <title>Re: Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315364#M15638</link>
      <description>&lt;P&gt;Try changing authentication method on MSSQL console to 'Windows Authentication' and retry&lt;/P&gt;</description>
      <pubDate>Tue, 28 May 2019 11:12:25 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315364#M15638</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2019-05-28T11:12:25Z</dc:date>
    </item>
    <item>
      <title>Re: Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315365#M15639</link>
      <description>&lt;P&gt;Try changing authentication method on MSSQL console to 'Windows Authentication' and retry&lt;/P&gt;</description>
      <pubDate>Tue, 28 May 2019 11:12:25 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315365#M15639</guid>
      <dc:creator>HP1</dc:creator>
      <dc:date>2019-05-28T11:12:25Z</dc:date>
    </item>
    <item>
      <title>Re: Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315366#M15640</link>
      <description>&lt;P&gt;can you show as a guide on changing, pls advise&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 09 Jun 2020 00:28:58 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/can-the-psm-sqlservermgmtstudio-connection-component-be-used/m-p/1315366#M15640</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2020-06-09T00:28:58Z</dc:date>
    </item>
  </channel>
</rss>

