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

Procedure

Click Applications & Tiers > Applications
In the Enhanced tab, click Add
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.
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
Click Add Application

Result

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