User guide

84 | Working with the AppAssure 5 Core
Configuring SQL Attachability Settings
Prior to running attachability checks on protected SQL databases, you must first
select a local instance of SQL Server on the Core machine that will be used to
perform the checks against the agent machine.
Complete the steps in this procedure to configure SQL attachability settings.
To configure SQL attachability settings
1. Navigate to the AppAssure 5 Core, and then click the Configuration tab.
2. From the Manage option, click Attachability.
The Attachability Check Settings window displays.
3. Select the local SQL Server instance to use to perform attachability checks for the
protected SQL databases.
You can choose from:
 SQL Server 2005
 SQL Server 2008
 SQL Server 2008 R2
 SQL Server 2012
4. Select the credential type. You can select from:
 Windows, or
 SQL
5. Specify the credentials with administrative privileges for the Windows or SQL
Server instances, as described in the following table.
6. Click Test Connection.
NOTE: If you entered the credentials incorrectly, a message displays to alert you that
the credentials test failed. Correct the credential information and run the connection
test again.
7. Click Apply.
Attachability checks are now available to be run on the protected SQL Server
databases.
Attachability requires a local instance of Microsoft SQL Server on the AppAssure Core machine.
This instance must be a fully licensed version of SQL Server procured from Microsoft or through
a licensed reseller. Microsoft does not allow the use of passive SQL licenses.
Text Box Description
User Name Enter a user name for logon permissions to the SQL server.
Password Enter a password for SQL attachability. It is used to control logon activity.