Pre-Installing SQL Database for CommServe - Cluster Environment

Use this procedure to pre-install the Microsoft SQL Server 2012 SP2 in a clustered environment. The installation steps will guide you to:

  • Install the SQL Server in the active node of a cluster group.
  • Create the NetApp instance in the cluster group.

Before You Begin

  • Create a Windows installation package (if not already installed) using the Download Manager. The installation package should contain the CommServe components (including the Database Engine). See Download Manager - Creating a Windows Installation Package for instructions on creating the installation package.
  • Review the following cluster environment requirements.
    • Verify that the latest Operating System service packs are installed on all nodes in the cluster group.
    • You will need to add a Group in Active Directory, and add a user to that group which will have full access to both nodes of the cluster. See http://technet.microsoft.com/en-us/library/ms345196.aspx for more information on the Microsoft SQL Server Group. This account could be the same account that the cluster services run under, but must be added to a Group.
    • The cluster should be functional, and the cluster group to which you want to install Microsoft SQL Server should be configured with a disk resource. You should review http://technet.microsoft.com/en-us/library/ms189910.aspx for the full set of prerequisites to installing Microsoft SQL Server on a cluster.
    • To avoid a failure of installation on Windows Server 2008 R2, make sure that the Windows Service Pack 1 is installed on the server computer.

Installing the SQL Server and Creating the NetApp Instance

  1. Log on to the active node of the cluster group as an Administrator or as a member of the Administrator group on that computer.
  2. Install .NET Framework 3.5 using the Server Manager Interface.

  3. From the 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.

  4. In the left-hand navigation area, click Installation and then click New SQL Server failover cluster installation.
  5. On the Setup Support Rules page, click OK after the wizard identifies any issues with the support rule files.
  6. On the Product Key page, click Next. The product key is already provided.
  7. On the License Terms page, select the I accept the license terms check box and then click Next.

  8. 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.

  9. 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.
  10. On the Setup Role page, click Next to proceed with the SQL Server Feature Installation.
  11. On the Feature Selection page, from the features to install, select Database Engine Services and Management Tools - Complete and then click Next.

  12. On the Features Rules page, click Next.
  13. On the Instance Configuration page, complete the following steps:
    • Enter the SQL Server Network Name. This is the name that will be available on the network for the clients. For example, the name could be sqlcluster<clientname>.
    • Click Named Instance and type NetApp.
    • Click Next.
  14. On the Disk Space Requirements page, review the disk space summary and click Next.
  15. On the Cluster Resource Group page, accept the default options and click Next.
  16. On the Cluster Disk Selection page, select the shared disks to be included in the SQL Server resource cluster group and click Next.
  17. On the Cluster Network Configuration page, we recommend you to have, at a minimum, the IPv4 check box selected.

    If you want the SQL Server to use a specific IP address, clear the DHCP check box for the IP Type you selected and then specify the IP Address and Subnet Mask. Click Next to continue.

  18. On the Server Configuration page, complete the following steps:
    1. In the Account Name and Password boxes for each SQL Server service, enter the username and password of the domain account that you used to log on to the computer.
    2. Click the Collation tab, and make sure the collation of the TEMPDB is set to to SQL_Latin1_General_CP1_CI_AS.
    3. Click Next.
  19. On the Database Engine Configuration page, complete the following steps in the Server Configuration tab:

    1. Click Mixed Mode (SQL Server authentication and Windows authentication).
    2. Enter and confirm the password for 'sa' SQL user in the Enter Password and Confirm password boxes.
    3. Click the Add Current User button.

    In the Data Directories and FILESTREAM tabs, accept the default values and then click Next.

  20. On the Error Reporting page, click Next.
  21. On the Cluster Installation Rules page, check if the rules ran successfully and then click Next
  22. 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.

  23. On the Complete page, click Close. The SQL Server is successfully installed.

    After the installation is complete on the active node, install SQL Server on passive node.

  24. Log on to the passive node of the cluster group as an Administrator or as a member of the Administrator group on that computer.
  25. Install .NET Framework 3.5 using the Server Manager Interface.

  26. From the 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.

  27. In the left-hand navigation area, click Installation, then click Add node to a SQL Server failover cluster and complete the installation on the passive node.

Post-Install Operations

Applying Latest SQL Server Updates

Install the latest cumulative updates and service packs provided by Microsoft on all the nodes where you installed the SQL Server. As a best practice, keep the SQL Server software up-to-date.

Tuning the SQL Server Memory Usage

The maximum memory used by the SQL Server should be 50% of the physical memory available in the computer (both active and passive nodes). Use the following steps to verify the SQL memory usage for the SnapProtect components.

  1. On the CommServe computer, open the Microsoft SQL Server Management Studio.
  2. Right-click the <Server Instance>, and then click Properties.
  3. From the Server Properties dialog box, select the Memory page on the left pane.
  4. In the Maximum server memory (in MB) box, specify 50% of the physical memory available in the computer.
  5. Click OK.