Processes
...
Credential Manager
Working with Credentials

SQL Credential

3min

Microsoft SQL is a relational database management system. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.

You can use these credentials to authenticate the following actions with Microsoft SQL:

Prerequisites

Create an account on a Microsoft SQL server.

Configure authentication

Step 1: Go to the Credentials Manager section and click Add New.

Step 2: Configuration basic info page

Document image
ο»Ώ

1.Name - Insert a name for the new configuration

2. Type - select SQL

3. Description - add details on the configuration (optional).

4. Click "Next Step'

MSSQL configuration :

Document image
ο»Ώ
  1. Server type - MSSQL
  2. Protocol type
  3. Server name: Hostname/IP to identify the location of the Microsoft SQL Server database
  4. Port number: Server port for the Microsoft SQL Server database
  5. Database name: The name of the Microsoft SQL Server database (optional, thus recommended)
  6. Encrypt: Select to use encrypted communication with the database server.
  7. Pooling
  8. Trust server certificate: Rely on the certificate provided by the server to verify secure data transfer.
  9. Authentication - Username&PAssword: The user name & password for the Microsoft SQL Server connection.
  10. You might need to whitelist PROCESIO outbound IP: 20.126.178.130

ο»Ώ

Updated 14 May 2023
Doc contributor
Doc contributor
Did this page help you?
PREVIOUS
FTP Credential
NEXT
SMTP Inbound Credential
Docs powered byΒ Archbee