Add a credential rule
You can add a credential rule so that unregistered or newly discovered instances are automatically registered with a credential.
To add a credential rule
- Select the Credential rules tab.
- Select Add or Add credential rule.
- Provide the Name and Description for the rule.
- Select Add condition.
- To select the criteria for the rule, make the following selections from the menus.
Start by making a selection for the Field list.
Then make a selection for Operator.
For the Value field, select or enter the value.
For details on the query criteria, see the following topics.
- Add any additional conditions or sub-queries for the rule.
- (Optional) To see the instances that match the rule criteria, select the Preview button. See the following topic for details.
- Select Next.
- Select from the following options:
Select from existing credentials
Select the credential that you want to apply to the credential rule.
Only the credentials with the type Microsoft SQL Server display.
Add credentials
Enter the Credential name and select the authentication option. Then select Next.
See Authentication options for SQL Server credentials.
Add any RBAC roles or permissions that you want to apply to the new credential.
- Select Add.
Any unregistered or any newly discovered instances that meet the rule criteria are registered with the associated credential in the rule. If you have the necessary RBAC permissions, you can view the instances that were registered in the audit messages. (Go to Security > Security events. Then select the Audit events tab.)