› The Kofax Search and Matching Server Administration › Configure and maintain existing database › Configure a Microsoft SQL Server connection

Configure a Microsoft SQL Server connection

This window enables you to set up the connection string for a Microsoft SQL Server.

You can configure a Microsoft SQL Server connection that connects to a table, view or a stored procedure, or a synonym.

In order to use a synonym, the following permissions are needed:

Limits

Synonyms have the following limitations:

  • Synonyms are supported for the following objects only:

    • Table

    • View

    • Stored Procedure

You can configure an Microsoft SQL Server database connection by following these steps:

  1. Select the database server from the Server Name list.
  2. Select the type of authentication and enter logon information if needed.
  3. Select the database from the Database Name list.
  4. Click OK to save the connection string.