Knowledgebase

Search:     Advanced search

Creating a DSN for a TestTrack SQL Server Database

Article ID: 389  |  Last updated: 30 Dec, 2014

This article helps you create an ODBC data source (DSN) for a SQL Server database used with TestTrack. When you convert your TestTrack native database to a SQL Server database, the RDBMS connection uses this DSN.

After you create the SQL Server TestTrack database, make sure you select this database when creating the DSN. The master database is selected by default when the DSN is created. If you do not change it, you may cause serious SQL Server problems.

Note: The following steps apply to Windows 7. Refer to the Windows help if you use a different version.

Adding a new DSN

  1. Create the TestTrack database in SQL Server.
  2. Choose Start > Control Panel > System and Security.
  3. Click Administrative Tools.
  4. Double-click Data Sources (ODBC). The ODBC Data Sources Administrator dialog box opens.
  5. Click the System DSN tab and then click Add. The Create New Data Source dialog box opens.
  6. Select the SQL Server driver and click Finish. The Create a New Data Source to SQL Server dialog box opens.
    Note: The SQL driver version must match the SQL Server version. For example, if you created a SQL Server 2012 database, use a SQL Server 2012 driver.
  7. Enter the name you used for the SQL Server database you created as the data source Name.
  8. Enter a Description.
  9. Select the SQL Server where the database resides.
  10. Click Next.
  11. Select an authentication option and click Next.
  12. Select Change the default database to and select the new TestTrack SQL Server database from the list.
    Note: Make sure you select the TestTrack database and not the default or master database.
  13. Click Next and then click Finish. A preview of the DSN configuration is displayed.
  14. Click OK. The DSN is added.
  15. Click OK to close the OBDC Data Source Administrator.

Adding a connection to the DSN

  1. Choose Start > All Programs > Seapine Software > TestTrack > TestTrack Server Admin and log in to the appropriate server.
  2. Click Server Options. The Options dialog box opens. 
  3. Click the RDBMS Connections category and then click Add. The Add Connection dialog box opens.
  4. Select ODBC - SQL Server as the Connection Type and select the Data Source Name you created.
  5. Enter the Username and Password based on the authentication you selected when you created the DSN.
  6. Click Test. The Test Connection dialog box opens and indicates if the connection is successful.
  7. Click OK to close the Test Connection dialog box.
  8. Click OK to close the Add Connection dialog box.
  9. Click OK to save the new RDBMS connection and close the Options dialog box.

You are now ready to convert your TestTrack native database to a SQL Server database. Refer to the TestTrack Server Admin help for information about converting databases.

Article ID: 389  |   Last updated: 30 Dec, 2014
Tags
database SQL Server DSN ODBC data source

Prev   Next
TestTrack SMTP Send Mail Error #503     Understanding TestTrack and Surround SCM Passwords