Symantec Privileged Access Management

  • Private Community
 View Only

  • 1.  TCP Service parameters for SSMS and MSTSC service

    Posted Apr 17, 2020 07:13 AM
    Hi All,

    I want to add SQL server management studio as TCP service so that the users can directly login to the database instead of logging to the windows server. I need help in getting the parameters so that I could setup this as a service under application.

    Same is needed for MSTSC. If you know or had set up. please assist. Thanks,

    Prince

    ------------------------------
    Prince
    ------------------------------


  • 2.  RE: TCP Service parameters for SSMS and MSTSC service
    Best Answer

    Broadcom Employee
    Posted Apr 17, 2020 05:53 PM
    Here are a couple of screen captures.  They're for services I created for mstsc and ssms.  For ssms, the following is the complete string that is in the Client Application field:  "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe" <Local IP> <First Port>.  Create your services like these, making sure that the paths match the locations of the applications on your PC.  You will likely not be able to get ssms to autoconnect to work, as there are options on the ssms login window that PAM would not know about.  This application would better be run using Transparent login.  I do not have information on making autoconnect work with mstsc.  I'm not sure that it will work.  There are some changes coming with 3.4 that should help.  The PAM Access Agent will be supporting RDP and you should have the ability to create an rdp proxy, which will support autoconnect.

    ------------------------------
    Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message