- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
04-12-2019 11:30 AM
05-22-2019 02:01 AM
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}"
05-28-2019 03:19 AM
@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.
05-28-2019 04:12 AM
Try changing authentication method on MSSQL console to 'Windows Authentication' and retry
05-28-2019 04:12 AM
Try changing authentication method on MSSQL console to 'Windows Authentication' and retry
06-08-2020 05:28 PM
can you show as a guide on changing, pls advise
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!

