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.
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>
Specifies an ACS collector whose database authentication account you want to change. If this subparameter is omitted, the local ACS collector is assumed.
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.
Specifies the password for the user account identified with the /Name parameter.
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
Audit Collection Services Administration (AdtAdmin.exe)