MS SQL Connection

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!

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!

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!