Adding Microsoft SQL Server over SAN to System Manager

You can use the Enhanced tab to add an instance of Microsoft SQL Server over SAN to System Manager.

About this task

The following procedure describes how to add a Microsoft SQL Server instance over SAN to System Manager. You can choose SMB as the export protocol only if the cluster is licensed for CIFS, which must be configured on the storage virtual machine (SVM).

Steps

  1. Click Applications & Tiers > Applications
  2. In the Enhanced tab, click Add
  3. Select Microsoft SQL Server instance from the menu.
    Note: The dropdown list includes a list of all available application types and template types.
    The Add Microsoft SQL Server Instance window is displayed.
  4. Specify the following details:
    • Database name
    • Database size and the required ONTAP service level
    • Number of server cores
    • Log size and the required ONTAP service level
    • Provision for Tempdb

      Specify if the server should be provisioned for Tempdb.

    • Export Protocol (SMB or SAN)

      Specify SAN

    • Host operating system
    • LUN format
    • Host mapping
  5. Click Add Application

Result

The Microsoft SQL Server instance over SAN is added to System Manager.