Opening a Microsoft SQL Server Database

Use the following procedure to start the Database Maintenance utility and open a Microsoft SQL Server database.

  1. Click (in Microsoft Windows 7) Start > Programs > Silk > Silk Test > Administration > Database Maintenance or (in Microsoft Windows 10) Start > Silk > Database Maintenance. The Database Maintenance utility starts.
  2. Click File > Open Database > SQL Server. The SQL Server Data Source Connection dialog box opens.
  3. Click Browse. The Select ODBC Data Source dialog box opens.
  4. Select the desired Microsoft SQL Server DSN, and then click Select. The SQL Server Data Source Connection dialog box opens and displays the selected DSN in the SQL Server Data Source text box.
    Note: The DSN for the default Silk Test Microsoft SQL Server 2008 Express database is Silk Test_SQL.
  5. In the Owner, User ID, and Password text boxes, enter the appropriate information for the Silk Test Microsoft SQL Server database instance.
    Note: The owner for the default Silk Test Microsoft SQL Server 2008 Express database is Silk TestDB, and the user with admin rights is SilkTestAdmin with password SilkTestAdmin.
  6. Click Open. The database opens and the Database Maintenance utility’s Tools menu options become available. If there are users currently connected to the selected database, a message is displayed. For more information, see Performing Maintenance on a Database with Connected Users.