Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?

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

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Can the PSM-SQLServerMgmtStudio connection component be used with SQL instance on dynamic ports? If so, how do I go about making connections successfully?

L2 Linker
5 REPLIES 5

L1 Bithead

The default PSM-SQLServerMgmtStudio connection component can connect to MSSQL Instances running on dynamic ports.

 

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.

 

If the SQL uses fixed ports, you can edit or duplicate another connector and modify the ClientApp to as follows:

"C:\[Path to ManagementStudio]\ssms.exe" -S "{Address},{Port}" -U "{UserName}" -P "{Password}" 

L2 Linker

@Josiah Winston​ 

We are also facing the same issue, after the inbound PSM server port is open we are able to login to the MSSQL instance.

 

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.

 

Please advice how to login directly via SQL server authentication from PSM.

Try changing authentication method on MSSQL console to 'Windows Authentication' and retry

Try changing authentication method on MSSQL console to 'Windows Authentication' and retry

can you show as a guide on changing, pls advise

 

  • 604 Views
  • 5 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!