In order to perform backup and restore operations on SQL Server instances, you have to register them with SQL Safe. To register SQL Server instances, you can find the option Add SQL Server instance available on the following tabs:
- Home tab
- Policies tab
- Operation History tab
- Instances tab
- Databases tab
When you click Add SQL Server instance, the wizard for registering new instances opens and you can find the following sections:
INSTANCE
Use this section to specify the instance or instances you want to register with SQL Safe for monitoring. To add new instances you can use any of the following options:
- Type the name of the instance inside the SQL Server instance box. Use a semicolon to separate multiple instances.
- Use the option BROWSE to get a list of instances discovered by the CWF service. Select those instances you want to register.
Click NEXT to go to the following section.
CREDENTIALS
In this section you can specify the credentials the CWF service uses to gather data about your instances. Choose whether you want to use the CWF service account or an alternate account for each type of connection. You have two type of credentials in this section:
SQL Connection Credentials
SQL Safe uses these credentials to connect and perform queries against your new registered SQL Server instances and collect configuration, availability, performance, and capacity data.
You can specify a Windows user or a SQL Server login Account Type.
WMI Connection Credentials
SQL Safe uses these credentials to connect to the instance's host computer and gather configuration and performance data.
Use the option TEST CREDENTIALS to make sure CWF can gather data for instances and host computers.
Click NEXT to go the following section.
FINISH
Use this section to review all your settings. You can go to previous sections to make any needed changes. Click FINISH to finish registering your SQL Server instances.