Help Center
Choose product document...
Veeam Availability Orchestrator 1.0
User Guide

Verify SQL Database

This step verifies the SQL database instance accessibility.

Verify SQL Database Important!

  1. To allow the script to run inside the guest OS of a processed VM, it is required that Microsoft PowerShell 3.0 and .Net Framework 4.0 must be installed on each VM for which you enable this step.
  2. To allow the script to connect to the verified SQL Server instance, VAO uses an account whose credentials are specified as values for either the Windows Credentials or SQL Credentials parameter. The account must have the VIEW ANY DATABASE permission. For more information, see Microsoft Docs.

You can override the following parameters for the Verify SQL Database step:

Parameter

Description

Default Value

Critical Step

Defines whether the step is critical for the VM recovery.

If you mark the step as Critical, its failure for a critical VM will halt the plan.

Yes

Windows Credentials

Credentials required to gain access to the SQL Server instance that uses Windows Authentication.

If the SQL Server instance you want to check uses Windows Authentication, the provided credentials will be used to connect to both the in-guest OS and the SQL instance. In this case, specify a value for the Windows Credentials parameter, and leave the SQL Credentials parameter value empty.

SQL Credentials

SQL account credentials required to gain access to the SQL Server instance that uses SQL Server Authentication.

If the SQL Server instance you want to check uses SQL Server Authentication, VAO will use SQL Server credentials to access the SQL instance, and Windows credentials to access the in-guest OS. That is why you must specify values for both the SQL Credentials and Windows Credentials parameters.

Note: The SQL Credentials parameter does not accept Windows credentials.

SQL Instance

Name of the SQL instance to check.

Note: To check all detected instances, select ALL.

ALL

SQL DB

Name of the SQL database to check.

Note: To check all detected databases, select ALL.

ALL

Execute Location

Defines whether the script will run on the Veeam Backup & Replication server or in-guest of the VM.

Guest OS (not editable)

Timeout

Maximum amount of time (in seconds) for the step to execute.

300

Retries

Number of retries that will be attempted if the step fails on the first try.

10

Failback & Undo Failover Action

Defines whether the step will be executed during the Failback and Undo Failover operations.

Skip

Test Action

Defines whether the step will be executed during plan testing in a virtual lab.

Execute

Veeam Large Logo

User Guide

Deployment Guide

Categorization Guide

RESTful API Reference