Boldon James

1

IP

MSSQL Server IP Address.

2

Port

Port number (optional, default: 1433).

3

Domain

Domain FQDN.

4

Database

Base database. (default: ClassifierEventsDB)

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

The user must have the following roles: ClassifierMaintenanceRole, ClassifierMaskedConsumerRole, ClassifierSupplierRole, ClassifierConsumerRole, and db_datareader.

6

Password

The Password of the provided username.

circle-exclamation

Was this helpful?