Microsoft SQL Server ODBC Driver

Applies To: Traffic between the Linux Web Server and the CommServe computer

If a firewall is placed between the Linux Web Server and the CommServe computer, you must configure the firewall to allow traffic between the two computers.

About This Task

Setting static ports is recommended because lost communication can occur if dynamic ports are used when the SQL Server instance is restarted.

Procedure

1. On the CommServe computer, verify that the SQL Server instance are set to listen on the static port 1433.

   For more information, see the following articles:

   • Windows: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)

   • Linux: Configure SQL Server settings on Linux - SQL Server

2. Set up connectivity to the static listener ports:

   • To route ODBC connection requests through a network proxy using Commvault firewall settings, complete the steps in Configuring Third-Party Connections Between Client Computers providing the following details:

     • Source client: The Web Server computer.

     • Source port: Any port that you want to set as a third-party port. This port will be defined in the [vpnclient] section of the network configuration file of the of the Web Server.

     • Destination client: The CommServe computer.

     • Destination port: The static listening port that you set on the SQL Server instance.

3. On the Linux Web Server computer, go to the Commvault registry location /etc/CommVaultRegistry/Galaxy/Instance001/Database/sINSTANCE, and then update Value data to 127.0.0.1

4. Update the connection parameters in the odbc.ini file by opening the /etc/odbc.ini file, and then updating the server name as 127.0.0.1 for [hostname_CommServ] as follows:

    
   [hostname_CommServ]
   driver = ODBC Driver 17 for SQL Serverserver = 127.0.0.1
   dsn = hostname_CommServ
   database = CommServ
   description = The CommServ Database
   ansinpw = yes

5. From the CommCell Console, add an additional setting on the Web Server computer 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	The Source port value that you entered above.

6. Restart all services on the Web Server computer.