Pre-Installation Setup for Commvault Simpana > Open TCP/IP Access to the Commvault Database
  
Version 10.0.01
Open TCP/IP Access to the Commvault Database
The following steps assume that the Commvault database is installed on an MS SQL server instance named COMMVAULT. Substitute the appropriate instance name as required.
Note: MS SQL Server must be set to Mixed-mode authentication and the login to be used for collection must be using SQL authentication.
1. Expand SQL Server Network Configuration.
2. Click Protocols for <COMMVAULT>.
3. Double-click TCP/IP.
4. Verify Enabled is set to Yes on the Protocol tab.
5. Scroll to IPAll, and in TCP Port enter 1433 on the IP Addresses tab. If you do not want to use the default MSSQL server port, you can enter another port number.
6. If you require a static port, clear the TCP Dynamic Port value. Note that any value, including 0, enables dynamic ports. See the Additional Static Port Configuration Steps.
7. Click OK.
8. Click SQL Server Services.
9. Right-click SQL Server <COMMVAULT> and select Restart.
Additional Static Port Configuration Steps
If you configured a static port during the port configuration process (Open TCP/IP Access to the Commvault Database), take the following additional steps.
On the Commvault CommCell Server:
1. Start the ODBC Data Source Administrator tool.
2. Select the Commvault database DSN (usually a system DSN) and click Configure.
3. Click Next.
4. Select With SQL Server authentication using a login ID and password entered by the user.
5. Enter the required User ID and password.
6. Click Client Configuration and make the following changes.
• In the Network libraries window, select TCP/IP.
• Enter the server name.
• De-select Dynamically determine port. ODBC uses port 1433 as a default, so it will be grayed out.
• Click OK.
7. Click Next and change the database, if needed.
8. Click Next, then Finish.
9. Click Test Data Source.
10. Click OK.