Microsoft System Center Configuration Manager (SCCM)

The Microsoft System Center Configuration Manager (SCCM) adapter uses SQL to fetch information about devices.

The Microsoft System Center Configuration Manager (SCCM) adapter connection requires the following parameters:

1. SCCM/MSSQL Server - The DNS / IP Address of the Microsoft SQL Server your SCCM instance is using (SCCM and Microsoft SQL Server instances may be installed on the same server).

2. Port (Optional).

3. Database - The name of the database inside the SQL Server (Usually starts with "CM_").

4. User Name - A user name with read-only permissions .
   Important Notes:

   • The best practice is to create a dedicate SQL local user for Axonius usage. For details, see Creating a Local Read-Only User for Microsoft SQL Server.
   • If you are using a domain user:
     • Specify the domain and the user name in the following format: domain\username.
     • The user must not be a service account.
     • Interactive logon must be enabled.

5. Password - The user's password. The password must not include ";".

6. Choose Instance - if you are using multi-nodes, choose the Axonius node that is integrated with the adapter. By default, the 'Master' Axonius node (instance) is used. For details, see Connecting Additional Axonius Nodes

Troubleshooting

• "Login failed" - If you are using a domain user, in the User Name field, specify the domain and the user name in the following format: domain\username.
• "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." - Enable interactive logon.