Agents - SRM SQL Agent - How To

Topics | How To | Related Topics

Add/Edit SQL Server Instance

Before You Begin

Required Capability: See Capabilities and Permitted Actions

To Add/Edit the Credentials of a SQL Server Instance:

  1. From the CommCell Browser, expand client computers right-click the icon for SRM SQL Agent, click All Tasks and select Add SQL Server Instance.
  2. In the Add SRM SQL Server Instance dialog box, add or edit the required fields.
  3. Click OK.
    For the SRM SQL Agent, Discovery data collection is possible with any user who has a login account for the SQL Server instance and access to the databases. However, in order to run an Analysis data collection, the user needs to be a member of the sysadmin Server Role. For users with limited rights (those without the sysadmin Server Role), the space used by database files will not be visible in the reports.

Back to Top