Installing a New SQL Server Instance
Once the new SQL Instance name is set, pre-install the SQL instance before installing the CommServe component. Use the following steps to install the SQL Instance using the software installation package.
- Log on to the client computer as an Administrator or as a member of the Administrator group on that computer.
- From the CommServe installation package that was created using the Download Manager, run the following program: WinX64\MSSQL\SQL_Enterprise_Edition\Setup.exe
The SQL Server Installation Center wizard is displayed.
- In the left-hand navigation area, click Installation and then click New SQL Server stand-alone installation or add features to an existing installation.
- On the Setup Support Rules page, click OK to start the setup of support rules.
- On the Product Key page, click Next. Because the SQL installation software is provided by Commvault, the product key is already provided.
- On the License Terms page, select I accept the license terms check box and then click Next.
- On the Product Updates page, click Next to include the latest SQL Server updates.
The Install Setup Files page is displayed, where the setup files are copied and then the installation automatically starts.
- On the Setup Support Rules page, check that the verification process returns successful results. If the setup returns a few warnings or failures, make sure to fix them before proceeding with the installation, then click Next.
- On the Setup Role page, click Next to proceed with the SQL Server Feature Installation.
- On the Feature Selection page - for the features to install, select Database Engine Services and Management Tools - Complete and then click Next.
- On the Installation Rules page, click Next after the setup completes running the rules.
- On the Instance Configuration page, select Named Instance and type the SQL Instance name assigned in the szUserSQLInstancename registry value, then click Next.
- On the Disk Space Requirements page, review the disk space summary and click Next.
- On the Server Configuration page, complete the following steps:
- On the Services Accounts tab, click the Account Name cell that corresponds to the SQL Server Database Engine service, and from the list click More to specify the local system account. The account name for the service should display NT AUTHORITY\SYSTEM.
- Keep the default account names for the SQL Server Agent and SQL Server Browser services.
- Click the Collation tab, and make sure the collation of the TEMPDB is set to SQL_Latin1_General_CP1_CI_AS then click Next.
- On the Database Engine Configuration page, complete the following steps in the Server Configuration tab:
- Click Mixed Mode (SQL Server authentication and Windows authentication).
- Enter and confirm the password for 'sa' SQL user in the Enter Password and Confirm password boxes.
- Click the Add Current User button.
- In the Data Directories and FILESTREAM tabs, accept the default values and then click Next.
- On the Error Reporting page, click Next.
- On the Installation Configuration Rules page, check if the rules ran successfully and then click Next.
- On the Ready to Install page, verify the features to be installed and then click Install. The Installation Progress page is displayed, showing the installation process.
- On the Complete page, click Close. The SQL Server is successfully installed.
After the above steps the CommServe installation will prompt for the SQL System Administrator (sa) password. Use the existing instance for the CommServe databases.
What to Do Next
The maximum memory used by the SQL Server should be 50% of the physical memory available (both active and passive nodes). During normal CommServe installation, this tuning of memory is done automatically. When pre-installing the SQL instance, this step needs to be performed manually. Use the following steps to verify the SQL memory usage for the CommServe component.
- On the CommServe, open the Microsoft SQL Server Management Studio.
- Right-click the <Server Instance>, and then click Properties.
- From the Server Properties dialog box, select the Memory page on the left pane.
- In the Maximum server memory (in MB) box, specify 50% of the physical memory available in the computer.
- Click OK.
Last modified: 2/14/2020 4:45:57 PM