Documentation Center

Configuring the Microsoft SQL Server ODBC Data Source

Before installing the Contenta software, you must configure the Microsoft SQL Server ODBC Data Source.

Procedure

  1. In the Windows Control Panel, click Administrative Tools > Data Sources.
  2. On the System DSN tab, click Add.
  3. Click SQL Native Client.
  4. Click Finish.
  5. In the Create a New Data Source to SQL window, enter a Data Source Name and Description, then select the Server.
  6. Click Next.
  7. Under How should SQL Server verify the authenticity of the login ID?, click With SQL Server authentication using a login ID and password entered by the user.
  8. Click Next.
  9. Accept the defaults in the resulting window:
    • Use ANSI quoted identifiers
    • Use ANSI nulls, packages and warnings
  10. Click Next.
  11. Accept the defaults in the resulting window.
    Ensure that Perform translation for character data is enabled.
  12. Click Finish.