# Microsoft System Center Configuration Manager (SCCM)

## Connection Requirements

{% stepper %}
{% step %}

### IP

MSSQL Server IP Address.
{% endstep %}

{% step %}

### Port

Port number (optional, default: 1433).
{% endstep %}

{% step %}

### Domain

Domain FQDN.
{% endstep %}

{% step %}

### Database

Base database.

{% hint style="info" %}
"cm\_"\
The database name must begin with `cm_`.
{% endhint %}
{% endstep %}

{% step %}

### 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.

{% hint style="info" %}
"Select"\
The user must have "List" privileges.
{% endhint %}
{% endstep %}

{% step %}

### Password

The Password of the provided username.
{% endstep %}

{% step %}

### Use No Lock

(default: False)
{% endstep %}
{% endstepper %}

{% hint style="warning" %}
⚠️ Attention\
Please perform a **connection test** to ensure there is a valid connection to the host.\
When the discovery operation is finalized, you will be able to see the details on the **Assets** page.
{% endhint %}