Add SRM SQL Server Instance

Use this dialog box to add a SRM SQL Server Instance, or to edit the credentials of an existing SRM SQL Server Instance.

Instance Name

The SQL Server instance name.

Displays the name of the SQL Server instance to be added. To select an instance, click one from the list.
If editing credentials for an existing instance, the Instance Name field cannot be edited.

Windows Authentication Credentials

User Name

The user name that must be used to log on to the computer with SRM SQL Agent installed.

Domain

The domain name of the computer with SRM SQL Agent.

Password

The associated password for this User Name.

SQL Server Authentication Credentials

User Name

The SQL Server user name that must be used by SRM SQL Agent to log on to SQL Server.

Password

The associated password for this User Name.

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.