Setting up SQL Server to work with Unica Discover

After installing SQL Server you need to configure it to work with Unica Discover.

Setting up SQL Server to work with Unica Discover

Use the information in Configuring SQL to work with Unica Discover - A reference table as a guideline for configuring SQL Server to work with Unica Discover. Consult SQL Server documentation for specific instructions with regard to configuring SQL server.

Table 1. Configuring SQL to work with Unica Discover - A reference table
Things to do Notes

Check the amount of RAM allocated to the SQL Server.

For a single-server topology, no more than 2 GB of the system RAM should be allocated to Microsoft SQL.

Connect to the Server

Login to SQL is managed via the Microsoft SQL Server Management Studio.

A login screen is displayed that allows you so specify the Unica Discover Server name and click Connect.

Note: If the Database Administrator completed a non standard configuration, you will need details from the administrator.

If after clicking Connect you are not connected to the database, contact the database administrator. The database administrator can provide you with the information needed to authenticate with the database.

Configure SQL Server Consumption

Set and confirm that your instance of SQL Server is configured to consume no more than 50% of the server's RAM.

Configure SQL Server for Mixed Authentication Mode

The following instructions are a guideline. Consult your Microsoft SQL Server documentation or articles from the MSDN for specific instructions.

  1. From the SQL Server Management Studio, right-click on the top most entry and select Properties.
  2. In the navigation pane, click Security.

    The security configuration information for the server is displayed in the viewing area.

  3. Make sure the radio button for SQL Server And Windows Authentication Mode is selected.
    Note: If any other parameter is set, contact the database administrator to confirm that modifying the authentication mode is allowed.
  4. Close the SQL Server Management Studio.
Configure SQL Server for TCP/IP Protocol Support

The following instructions are a guideline. Consult your Microsoft SQL Server documentation or articles from the MSDN for specific instructions.

  • Open the SQL Server Configuration Manager from the start menu.
  • Expand the SQL Server Network Configuration tab.
  • Make sure that TCP/IP is enabled.
  • Highlight Protocols
  • For MSSQLSERVER and ensure that TCP/IP is Enabled. If TCP/IP is not enabled, right-click on TCP/IP and change the setting to Enabled.
Configuring SQL Server for DATABASE Port 1433

Ensure that the TCP DYNAMIC PORTS is not enabled.

If the database has been configured using dynamic ports contact will again be needed with the local database administrator to have them disabled.