• State Not Answered
  • Replies 2 replies
  • Subscribers 27 subscribers
  • Views 256 views
  • Users 0 members are here
Options
Related

MS SQL Connection

andrey lobas
8 months ago

HI All!

Tell MS SQL Managment studio to indicate the address of the target server if the Inband destination selection * connection is configured in SPS?

  • 0 8 months ago

    Hi Andrey,

    You can point the MS SQL Management studio client "Server Name" to the SPS IP address and specify the target SQL server in the  "Login" field for example: sa%{Target SQL Server}

    Thanks!

  • 0 8 months ago in reply to Tawfiq.Ahmad

    and if using an LDAP Authentication policy where you can map an LDAP User to Local SQL user and have an SPS Local credential store auto inject the Local SQL user credentials then you can use:

    Server Name: SPS IP Address
    Login: gu={LDAPUser}%{LocalSQLUser}%{TargetSQLServer}

    Here the user will provide the password for LDAP user only and SPS will auto inject the local SQL user credentials from a local credential store as an example.

    Thanks!