Set up Microsoft SCCM for Integration
Set up Microsoft SCCM with a user account that Cortex
XSOAR can use when securely connecting to it.
The only configuration that’s required for
Microsoft SCCM is the creation of a user for XSOAR to authenticate
itself to the SQL server when connecting.
- Configure a user account for Cortex XSOAR.
- Log in to the Microsoft SQL Server Management Studio with an account that has permissions to create user accounts.
- ClickSecurityin the navigation panel, right-clickLogins, and then clickNew Login.The Login - New dialog box appears.
- In the General panel, configure a user account with either Windows authentication or SQL Server authentication and specify a default SQL database to which the account has access.Windows authentication: Select this option to authenticate the user through Active Directory.Login name: Enter the WindowsDOMAINNAME\USERNAMEfor a user that was previously configured in Active Directory and has read-only access to the SQL server. For example:ACMECORP\XSOARorSQL Server authentication: Select this option to authenticate the user from accounts stored locally on the SQL server.Login name: Enter a name for the user account. For example:XSOARPasswordandConfirm Password: Enter a password for the user account.User must change password at next login: (clear)Default database: Choose the database from which you want Cortex XSOAR to retrieve device information.
- In the User Mapping panel, give the account read-only access to the default database as well as any additional databases.Users mapped to this login: Select the check box for the SQL databases that you want to allow the account to access.Database role membership for<database-name>: For each database, selectdb_datareader.
- Save the new user account.ClickOKto save the new login configuration.
