Configuring credentials for an individual SQL Server resource

You can configure credentials to perform data protection jobs on individual SQL Server resources for each user. While you can configure the credentials globally, you might want to do this only for a particular resource.

About this task

Steps

  1. In the left navigation pane, click Settings.
  2. In the Settings page, click Credential.
  3. To add a new credential, click New.
  4. In the Credential page, configure the credentials:
    For this field… Do this…
    Credential name Enter a name for the credentials.
    Username Enter the user name used for SQL Server authentication.
    • Domain administrator or any member of the administrator group
      Specify the domain administrator or any member of the administrator group on the system on which you are installing the SnapCenter plug-in. Valid formats for the Username field are:
      • NetBIOS\UserName
      • Domain FQDN\UserName
    • Local administrator (for workgroups only)

      For systems that belong to a workgroup, specify the built-in local administrator on the system on which you are installing the SnapCenter plug-in. You can specify a local user account that belongs to the local administrators group if the user account has elevated privileges or the User Access control feature is disabled on the host system. The valid format for the Username field is: UserName

    Password Enter the password used for authentication.
    Authentication mode Select the SQL Server authentication mode.

    You can also choose Windows authentication if the Windows user has sysadmin privileges on the SQL server.

    Host Select the host.
    SQL Server Instance Select the SQL Server Instance.
  5. Click OK to add the credential.
  6. In the left navigation pane, click Resources.
  7. In the Resources page, select Instance from the View list.
    1. Click , and then select the host name to filter the instances.
    2. Click to close the filter pane.
    Note: The credential option does not apply to databases and availability groups.
  8. In the Instance Protect page, protect the instance, and if required, click Configure Credentials.
    If the user who is logged in to the SnapCenter Server does not have access to SnapCenter Plug-in for Microsoft SQL Server, then the user has to configure the credentials.
  9. Click Refresh Resources.