Select a credential for a SQL Server instance or replica
To allow for full discovery of SQL Server assets, you must select the credential that you want to use for the instances or replicas. You can select from the existing server credentials or create a new credential.
Note:
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. The date reflects when the credential was added or updated; it does not indicate if the credential is valid.
Review the recommendations and requirements for the type of credentials that you want to use for authentication.
See About SQL Server credentials.
See Select an existing credential for a SQL Server instance or replica.
See Add a new credential for a SQL Server instance or replica.
For availability groups, each replica in must be registered with credentials.
To select an existing credential for a SQL Server instance or replica
- 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.
- Click Select from existing credentials.
- Click Next.
- Select the credential that you want to use for the selected assets and click Next.
For availability groups, each replica in must be registered with credentials.
To add a new credential for a SQL Server instance or replica
- 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.
- Select Add credentials and click Next.
- Select the authentication option.