How to configure an ODBC test with SilkPerformer Agents using NT Database Authentication on SQL Server.
There are two possibilities for connecting to a SQL Server database with a ODBC Data Source:
1. Using Windows NT Authentication using the Network Login ID.
2. Using SQL Server Authentication using a Login ID and Password entered by the user
When distributing virtual users across Agents during an ODBC loadtest you need to have the "ODBC DATA SOURCE | SYSTEM DSN" configured on the Agent machine as each Agent install requires an ODBC driver in order to generate ODBC traffic. This System DSN should match the DSN you have configured on the Silk Performer controller.
However if an Agent connects to the ODBC Data Source using NT Authentication you will also need to specify the NT account and password that will be used to log into the Agent machine, this can be done in the Silk Performer MMC as follows:
- TOOLS | SYSTEM CONFIGURATION MANAGER | APPLICATIONS | Silk Performer - AUTHENTICATION
- Enter the NT Account Domain Username and Password.