Setting up SQL Server to work with HCL Discover

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

Setting up SQL Server to work with HCL Discover

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

Table 1. Configuring SQL to work with HCL 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 HCL 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.
Configuring Custom Password for DCADMIN/DCUSER in SQL Server To set up a custom password for the DCADMIN/DCUSER users in SQL Server, complete the following steps:
  1. Before installing HCL Discover, access the SQL Server.
  2. For the user DCADMIN/DCUSER, access the Login Properties and deselect the Enforce password policy.
  3. Click OK.
  4. Perform the installation of HCL Discover. SQL Server accepts default password and the installation completes successfully.
  5. Post installation, access the registry and update the client-generated password and save the changes.
  6. Access the SQL Server abd open the Login Properties for the user DCADMIN/DCUSER.
  7. Update the Password and Confirm password.
  8. Select Enforce password policy and click OK.
  9. Restart all Discover services to verify the change.
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.