Loading...

Preparing Your Environment to Hide the CommServe Database SQL Server Instance

By default, the CommServe software uses the Microsoft SQL Server Browser service to enable clients and other Commvault applications to connect to the CommServe database through dynamic ports. If you want to prevent the CommServe database instance from being exposed by the SQL Server Browser service, you can configure the CommServe database to use a static port and turn off the SQL Server Browser service.

Before You Begin

  • You must have ODBC Data Source Administrator installed on your CommServe Computer.

Procedure

  1. On the CommServe computer, configure the Microsoft SQL Server that is running the CommServe database to use a static port.

    For instructions, see Configure a Server to Listen on a Specific TCP Port on the Microsoft SQL Server documentation website.

  2. Optional: To validate that the CommServe SQL Server is using the correct port number, do one or both of the following:
    • View the SQL Server error log. The new port number should appear in the log.

      For instructions, see View the SQL Server error log on the Microsoft SQL Server documentation website.

    • In SQL Server Management Studio, connect to the SQL Server using the following string:

      TCP:CommServeHostName\Commvault,newPortNumber

      where CommServeHostName is the host name of the CommServe computer and newPortNumber is the new, static port number for the CommServe SQL Server.

  3. For each SQL Server instance installed in your environment that makes connections to the CommServe database, including the CommServe computer, create a server alias for the CommServe SQL Server instance using the following values:

    Field

    Description

    Example Value

    Alias Name

    Enter CommServeHostName\Commvault, where CommServeHostName is the host name of the CommServe computer.

    COMMSERVE\Commvault

    Port No

    Enter the static port number configured for the CommServe SQL Server instance.

    5678

    Protocol

    Enter the protocol to connect to the server (TCP/IP).

    TCP/IP

    Server

    Enter the same value as in Alias Name.

    COMMSERVE\Commvault

    For instructions, see Create or Delete a Server Alias for Use by a Client on the Microsoft SQL Server documentation website.

  4. On the CommServe computer, configure the Microsoft ODBC Data Source Administrator to include the new CommServe SQL Server port number as follows:
    1. Open ODBC Data Source Administrator.
    2. Click the System DSN tab, select a data source form the System Data Sources table, and then click Configure.

      The Microsoft SQL Server DSN Configuration dialog box appears.

    3. Under Which SQL Server do you want to connect to?, in the Server box, change the value to:

      CommServeHostName\Commvault,newPortNumber

      where CommServeHostName is the host name of the CommServe computer and newPortNumber is the new, static port number for the CommServe SQL Server (for example, COMMSERVE\Commvault,5678).

    4. Click Finish.
  5. To the CommServe computer, add the additional settings as shown in the following table.

    For instructions about adding an additional setting from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

    Additional setting

    Category

    Type

    Value

    nPort

    Database

    Integer

    Enter the static port number of the CommServe SQL Server instance.

    nWFPort

    Database

    Integer

    Enter the static port number of the CommServe SQL Server instance.

    nCloudPort

    Database

    Integer

    Enter the static port number of the CommServe SQL Server instance.

What to Do Next

  1. Verify that you can start and run your Commvault applications.
  2. Follow the instructions in the Microsoft SQL Server documentation to hide the CommServe database instance and stop the SQL Browser Service:

Last modified: 4/9/2020 8:32:21 AM