Versions Compared

Key

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

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

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 User name column  column in this window refers to the user name for a Windows user account or the login information for a SQL Server account.

Editing Properties

You can edit properties for an instance in the Manage SQL Server instances window.  Select your instance and click Edit Properties from the gear icon under the Actions column or the top of the window. The Edit Instance Properties window opens where you can change the Owner, Location, Comments, Data Collection Settings, and Credentials. For more information about these properties, go to Editing your SQL Server instances properties.

Tip

You cannot edit properties for several instances in the Manage SQL Server instances window of the Administration tab, but you can execute this action from the Instances tab. For more information, go to What bulk options are available for several instances?

Click the Image Added 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 respective option the Edit Credentials option on the top of the window, and then click Edit Credentials. . Then, SQL Enterprise Job Manager opens a new window for editing credentials where you can choose which Account Type to use to gather informationchange the following credentials:

  • SQL connection credentials - 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 credentials collect Windows configuration data of the computers hosting your registered instances. 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 use the option option TEST CREDENTIALS to  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:

  • General - Change or add information about Owner, Location, Comments, Data Collection Settings, and Task monitoring.  
  • Credentials - 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 new maintenance mode settings, including schedule type, frequency, duration, and other additional options. 

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

  • Owner, Location, and Comments. 
  • Data Collection Settings
Warning

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

SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...