You can assign credentials to MS-SQL servers on the Enterprise Workloads Management Console. These credentials are secured securely. When you assign a credential to an MS-SQL server, they are automatically assigned it to the Enterprise Workloads service on the SQL server. These credentials do not get overwritten by default user settings during an agent upgrade. Assigning credentials to SQL servers is not mandatory during server registration.
You can manage credentials for the MS-SQL servers from the Registered Servers page.
The Credentials column in the Registered Servers page displays the credentials assigned to each server in the list.
You can use the Manage Credentials option to:
Create a new credential for MS-SQL servers
Assign credentials
Unassign credentials
📝Note:
You can Update or Delete credentials from Settings > Credential Store. For more information, see Credentials Store.
.
Manage Credentials
Log in to the Management Console.
Click Protect > MS-SQL. Note that if the All Organizations menu is enabled, you have to first select an organization and then click Protect > MS-SQL.
In the Registered Servers page, select the SQL server whose credentials you want to manage, click more options, and then click Manage Credentials.
In the Manage Credentials dialog box, perform the following tasks:
Field | Description |
Add Credential | Create a new credential. In the Add Credentials dialog box, enter the following details:
|
Assign | Assign the selected credential to the server. The selected credential replaces any previously assigned credential. 📝Note: Ensure that you have Windows user Administrator privileges when assigning credentials to an MS SQL Server. |
Unassign Credential | Unassign the selected credential from the server. 📝Note: Some functions like a client upgrade may not work if the credentials are unassigned from the server. |
You can use the same credentials for multiple SQL servers. However, an SQL server can only be assigned a single set of credentials.