Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Take into account Consider that the 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.

...

  • SQL connection credentials  - these These credentials collect information from your registered SQL Server instances. You can choose from the following account types: SQL Enterprise Job Manager service account, SQL Server login account, or Windows user account. These last two options require you to provide the respective username/login and password. 
  • WMI connection credentials - these These credentials collect   Windows configuration data of the computers hosting your registered instances.  You You can choose from one of the following account types: SQL Enterprise Job Manager service account or Windows user account. The last option requires you to provide the respective username/login and password. 

...

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

Select the instance for which you want to edit its properties, click the gear icon or use the 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:

  • General  - change Change or add information about Owner, Location, Comments, Data Collection Settings, and Task monitoring.  
  • Credentials  - edit Edit the credentials you use to collect SQL Server instance information (SQL connection credentials) and the credentials used to gather information from your instances host computers (WMI connection credentials) 
  • Maintenance  - specify Specify new maintenance mode settings, including schedule type, frequency, duration, and other additional options. 

...

Warning

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

...