Search:     Advanced search

Creating DSNs for SQL Server Databases

Article ID: 389  |  Last updated: 29 Sep, 2016

To host Seapine License Server, Surround SCM, or TestTrack data in a SQL Server database, you must create an ODBC system data source name (DSN) to store database connection information. Each SQL Server database you create to use with Seapine products requires a unique DSN.

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

  1. Create an empty 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 Source 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 driver must support connections to the SQL Server version used to create the database. See the SQL Server documentation for information about driver compatibility or ask your DBA for help.

  7. Enter a unique Name. If possible, use the same name as the database so it is easy to identify the associated DSN.
  8. Enter a Description, such as the purpose of the database.
  9. Select the SQL Server that hosts the database and click Next.
  10. Select an authentication option and click Next.
  11. Select Change the default database to. Select the database you created from the list. Do not select the default or master database because this may cause SQL Server problems.
  12. Select the following options and click Next.
    • Use ANSI quoted identifiers
    • Use ANSI nulls, paddings, and warnings
  13. Select Perform translation for character data and click Finish. A preview of the DSN configuration is displayed.
  14. Click Test Data Source to make sure the DSN can connect to the SQL Server. If the connection fails, use the Back buttons to update the settings.
  15. Click OK to add the DSN.
  16. Click OK to close the OBDC Data Source Administrator.

After the DSN is added, select it when changing or converting the server database in the Seapine License Server Admin Utility or adding an RDBMS connection in Surround SCM or the TestTrack Server Admin Utility

Article ID: 389  |   Last updated: 29 Sep, 2016
database SQL Server DSN ODBC data source

Also listed in
folder Surround SCM
folder TestTrack

Prev   Next
Cannot Connect to Server after Upgrading to Mac OS X 10.6     Surround SCM Cannot Connect to the License Server