• Article

AdtAdmin.exe /SetDBAuth

 

Updated: May 13, 2016

Applies To: System Center 2012 R2 Operations Manager, System Center 2012 - Operations Manager, System Center 2012 SP1 - Operations Manager

The /SetDBAuth parameter specifies the authentication method that the ACS collector uses to access the ACS database. The two available authentication methods are Windows Authentication and SQL authentication. Windows Authentication is the most secure method but can be used only if the computer that runs the ACS collector and the computer that hosts the ACS database belong to the same Active Directory domain or to domains that trust each other.

Using the /Name and the /Pwd subparameters automatically configures the ACS collector to use SQL authentication. To check which authentication method the ACS collector is using, run the /GetDBAuth parameter.

Syntax

To specify that the ACS collector use Windows Authentication, use the following syntax:

AdtAdmin.exe /SetDBAuth [/Collector:<CollectorName>]

To specify that the ACS collector use SQL authentication and identify the user name and password of the user account that can access the ACS database, use the following syntax:

AdtAdmin.exe /SetDBAuth [/Collector:<CollectorName>] /Name:<UserAccount> /Pwd:<Password>

Subparameter

Description

/Collector:CollectorName

Specifies an ACS collector whose database authentication account you want to change. If this subparameter is omitted, the local ACS collector is assumed.

/Name:UserAccount

Identifies the new user account name for the ACS collector to use to connect to the ACS database. This subparameter should be used only when you want to use SQL authentication as the authentication method between the ACS collector and the ACS database.

/Pwd:Password

Specifies the password for the user account identified with the /Name parameter.

Example

Use the following example to change the user account used by the ACS collector to connect to the ACS Database to an account that has a user name of "SQLDatabase" and a password of "SQLPass#1":

AdtAdmin /SetDBAuth /Name:SQLDatabase /Password:SQLPass#1