Add credentials to SQL Server instances or replicas
To allow for full discovery of SQL Server assets, you must add new credentials or select the existing server credentials for the instances or replicas. Review the requirements for the SQL Server credential option that you want to use.
See About SQL Server credentials.
You can select the credentials you want to apply to an instance or replica from the list of existing SQL Server credentials.
For availability groups, each replica in must be registered with credentials.
To select credentials for SQL Server instances or replicas
- On the left, click Workloads > Microsoft SQL Server.
- Click on the Instances tab.
- Select the check box for the instances or replicas and click Manage credentials.
- Choose Select from existing credentials and click Next.
- Select the credential that you want to use for the selected assets and click Next.
NetBackup validates the credentials.
- The database and the availability group discovery begin after the credentials are validated. However, these assets may not appear in the web UI immediately. They appear after the discovery process completes. Note that the dates reflect when the credential was added or updated and does not indicate if the credential is valid.
If the credentials you want to apply to an instance or replica are not available, you can add them to NetBackup.
For availability groups, each replica in must be registered with credentials.
To add new credentials to SQL Server instances or replicas
- On the left, click Workloads > Microsoft SQL Server.
- Click on the Instances tab.
- Select the check box for the instances or replicas and click Manage credentials.
- Choose Add credentials and click Next.
- Enter a credential name.
- See About SQL Server credentials.
Select one of the following options:
Use credentials that are defined locally on the client and click Next.
Use these specific credentials
Provide the User name, password, and Domain that are associated with the credentials. Click Next.
- The Permissions screen displays the roles that have access to the credential.
- Click Next.
The database and the availability group discovery begins after the credentials are validated. However, these assets may not appear in the web UI immediately. They appear after the discovery process completes. Note that the dates reflect when the credential was added or updated and does not indicate if the credential is valid.