Loading...

Changing the SQL Server Default Ports

Another step to harden access to the SQL database on the CommServe server is to change the default service ports. A default installation of SQL Server 2012 use TCP port 1433 for client requests and communications. These ports are well known and are common targets for hackers.

Procedure

  1. From the Start menu, choose All Programs | Microsoft SQL Server 2012 | Configuration Tools | SQL Server Configuration Manager.
  2. Expand the SQL Server 2012 Network Configuration node and select Protocols for the SQL Server instance to be configured.
  3. In the right pane, right-click the protocol name TCP/IP and choose Properties.
  4. In the TCP/IP Properties dialog box, select the IP Addresses tab.

    Note: There is a corresponding entry for every IP address assigned to the server.

  5. Except for the IP addresses under IPAll, clear the values for both the TCP Dynamic Ports and TCP Port for each IP address.
  6. In the IPAll section for each instance, type in a new port for SQL Server 2012 requests and communications. Port number should be in the dynamic range 49152-65535 to avoid conflict with Well-Known and Registered ports.
  7. Click Apply.
  8. 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.

  9. Restart the SQL Server Services.

Note: If a Web Server component has been installed on a host other than the CommServe, update the ODBC connection information with the new SQL port number. Consult Commvault documentation on Post-Installation Configurations for Web Server and Web Console.

Last modified: 4/17/2019 1:33:40 PM