Loading...

Pre-Installing the Microsoft SQL Server Software on a Non-Cluster Environment

By default, SnapProtect installs the Microsoft SQL Server 2014 Standard Edition during the installation of the CommServe software or other server packages. For more information on scalability, performance, and other features supported by the standard edition, refer to the Microsoft documentation.

Based on your environment requirements, if you need to install the SQL Server before installing SnapProtect server packages, use the steps in this procedure to install the SQL Server manually.

Before You Begin

  • Create an installation package by using the Download Manager. The installation package must include the Microsoft SQL Server and the necessary SnapProtect server packages, such as the CommServe or Workflow Engine. For instructions about creating the package, see Downloading Software for Windows Computers Using the Download Manager.
  • The computer on which you want to install the SQL Server must have the following properties:
    • The latest Microsoft ODBC Driver for SQL Server must be installed.
    • The computer must have a static IP address.

Installing the SQL Server and Creating the NetApp Instance

  1. Log on to the client computer 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\ThirdParty\MSSQL\SQL_Standard_Edition\Setup.exe

    The SQL Server Installation Center wizard is displayed.

  4. From the left-hand navigation area, click Installation. Then, on the right pane, click New SQL Server stand-alone installation or add features to an existing installation.
  5. On the Product Key page, click Next. The product key is already provided.
  6. On the License Terms page, select the I accept the license terms check box and then click Next.

  7. On the Microsoft Update page, determine whether you want to enable the Microsoft Update feature and then click Next.

    The Install Setup Files page is displayed, where the setup files are copied and then the installation automatically starts.

  8. On the Setup Role page, click Next to proceed with the SQL Server Feature Installation.
  9. On the Feature Selection page, from the features to install, select Database Engine Services and Management Tools - Complete and then click Next.

  10. On the Instance Configuration page, click Named Instance, specify a name for the instance (for example, you can type NetApp), and then click Next.
  11. On the Server Configuration page, complete the following steps:
    1. In 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.

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

  13. On the Feature Configuration Rules page, check whether the rules ran successfully and then click Next.
  14. On the Ready to Install page, verify the features to be installed and then click Install.

    The Installation Progress page is displayed indicating the installation process.

  15. On the Complete page, click Close.

    The SQL Server is successfully installed.

Postinstallation Tasks

The following sections describe the tasks that you must perform to complete the Microsoft SQL Server installation:

  • Apply latest SQL Server updates

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

  • Tune the SQL Server memory usage

    The maximum memory used by the SQL Server should be 50% of the physical memory available in the computer.

    Use the following steps to tune the SQL Server memory usage for SnapProtect:

    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, on the left pane, select the Memory page.
    4. In the Maximum server memory (in MB) box, specify 50% of the physical memory available in the computer.
    5. Click OK.

  • Install the server package

    You can now install the CommServe software or the appropriate server package on the computer where you installed the SQL Server software.