Creating a Data Source Name for a SQL Server Database

Note: Silk Test Workbench cannot use 64-bit DSNs. To create a DSN for a 64-bit machine, click (in Microsoft Windows 7) Start > Silk > Silk Test > Administration > Data Sources (ODBC) or (in Microsoft Windows 10) Start > Windows Administrative Tools > ODBC Data Sources (32-bit) and create a 32-bit DSN. You can also use the WOW64 tools located at C:\WINDOWS\SysWOW64\odbcad32.exe.

On each client computer connecting to a SQL server database, perform the following steps to set up a DSN:

  1. Navigate (in Microsoft Windows 7) to Start > Silk > Silk Test > Administration > Data Sources (ODBC) or (in Microsoft Windows 10) to Start > Windows Administrative Tools > ODBC Data Sources (32-bit). The ODBC Data Source Administrator dialog box opens.
  2. Click the System DSN tab, then click Add. The Create New Data Source dialog box opens. This dialog box lists the available ODBC drivers.
  3. From the list of drivers, select the ODBC Driver 11 for SQL Server and click Finish. The Create a New Data Source to SQL Server dialog box opens.
  4. In the Name box, type the data source name.

    Enter a logical name as this name appears as the database name in the logon screen.

  5. In the Description text box, type a description for the data source. For example, Connection to Silk Test Workbench database.
  6. In the Server text box, enter the server name or select it from the drop-down list.
  7. Click Next.
  8. Perform one of the following:
    • If user(s) using the DSN to access the SQL Server database are connecting with non-native credentials, select the With Windows authentication using the network login ID option.

    • If user(s) using the DSN to access the SQL Server database are connecting with native authentication, select the With SQL Server authentication using a login ID and password entered by the user option. Make sure the Connect to SQL Server to obtain the default settings for the additional configuration options check box is checked. Type the users native SQL Server logon credentials in the Login ID and Password text boxes.

  9. Click Next.
  10. Check the Change the default database to check box, and then select your database name from the list.
  11. Accept all the other entries and click Next until the last panel in the wizard appears.
  12. Accept the defaults and click Finish.
  13. To test the connection, click Test Data Source. The SQL Server ODBC Data Source Test dialog box opens.
  14. Click OK.

    The ODBC Data Source Administrator dialog box reappears. The newly created data source appears in the System Data Sources list.

  15. Click OK.