Microsoft System Center Configuration Manager (SCCM)

Connection Requirements

1

IP

MSSQL Server IP Address.

2

Port

Port number (optional, default: 1433).

3

Domain

Domain FQDN.

4

Database

Base database.

circle-info

"cm_" The database name must begin with cm_.

5

Username

Value provided in username must have "Read" permission to devices and MSSQL server.

To create a User:

  • Open MSSQL Server Management Studio.

  • Go to Security folder and right click Login after that click New Login.

  • Select the authentication used in the server.

  • Fill in the details and select your database in Default Database.

  • Save User.

  • Login to the database with this user once to avoid an error.

circle-info

"Select" The user must have "List" privileges.

6

Password

The Password of the provided username.

7

Use No Lock

(default: False)

circle-exclamation

Was this helpful?