SQL Server Settings for SDL Contenta

Follow these steps only if you are using an MSSQL database. If using an Oracle database, see "Configuring the Oracle ODBC Data Source."

About this task

Follow the steps below to verify that SQL Server is configured with the required settings for use with SDL Contenta.

Procedure

  1. Verify the SQL Server Product Version; from the Start menu on your MSSQL server, click Microsoft SQL Server Management Studio.
  2. Connect to the database engine using Windows Authentication—for example:
    • Select a server from the Server name drop‐down list.
    • Click Connect.
  3. Click on New Query icon in the upper left of the Server Management Studio window.
  4. Enter the following query in the query pane (example below):
    SELECT SERVERPROPERTY (ʹeditionʹ) as ʹEditionʹ,
    SERVERPROPERTY(ʹproductversionʹ) as ʹProduct Versionʹ,
    SERVERPROPERTY (ʹproductlevelʹ) as ʹPatchʹ
  5. Press F5 to execute the query.
  6. Check that the Login Mode is mixed mode by entering the statement below in the Microsoft SQL Server Management Studio window.

    You should still be connected to the database in the Microsoft SQL Server Management Studio window. If not, or if executing this step on its own, connect to the database—see step 2 in this topic.

    xp_loginconfig ʹlogin modeʹ

  7. Press F5 to execute the query.
  8. To verify the SQL Server Remote Connection, from the Start menu select:
    All Programs > Microsoft SQL Server 20nn >
    Configuration Tools > SQL Server Surface Area
    Configuration

    The SQL Server 20nn Surface Area Configuration window appears.

  9. Click on Surface Area Configuration for Services and connections.
    A window with SQL Server services appears.
  10. Click Remote Connections under Database Engine.
    Services and connection types appear.
  11. Verify that Local and remote connections and Using both TCP/IP and named pipe are selected. If not, click in the radio button next to each.
  12. Click OK.
  13. Close the Surface Area Configurationwindow by clicking the X in the upper right corner of the window.