To view all your registered SQL Server instances, their respective credentials, and login information, you can also go to the Administration tab and click Manage SQL Server Instances under the Instances section. 

SQL Enterprise Job Manager opens a new window with all your monitored instances, their user account type, and user names specified to collect instances information. 

Consider that the User name column in this window refers to the user name for a Windows user account or the login information for a SQL Server account.

Click the  more options icon to select the information you want to hide or show on the list.

Editing Credentials

You can bulk edit credentials for several selected SQL Server instances.

Select those instances for which you want to edit their credentials, click the gear icon or use the Edit Credentials option on the top of the window. Then, SQL Enterprise Job Manager opens a new window where you can change the following credentials:

You can use the option TEST CREDENTIALS to make sure that the credentials you are selecting can connect to the respective SQL Servers and gather their information. 

Editing Properties

You can edit properties for an instance in the Manage SQL Server Instances window.

Select the instance you want to edit its properties, click the gear icon or use the Edit Properties option on the top of the window. Then, SQL Enterprise Job Manager opens a new window where you can change the following properties:

If you select several instances, SQL Enterprise Job Manager opens a window where you can bulk edit the following information:

Only users with Administrator roles can access the Administration tab, and, therefore, Managing SQL Server instances is only available to this user role.



 |   |  |  |  |