Microsoft SQL Server
In this doc, we will cover how to setup a Connection to a Microsoft SQL Server.
Prerequisites
- Access credentials
- Data location on Microsoft SQL Server
Create new Microsoft SQL Server connection

Figure 1

Figure 2
In Figure 2 above:
- Access Type (required): The type of connection: Read-Only, Write-Only, Read-Write.
- Connection Name (required): The name to identify this connection with, such as 'MS SQL Server Connector'.
- Host (required): IP or the hostname of the Microsoft SQL server.
- Port (optional): Host server port number.
- Database Name (required): Name of the database.
- Choose Credentials (required): Choose from existing credentials or create new credential for connecting to Microsoft SQL server if 'Required Credentials' checkbox is selected.

Figure 3
In Figure 3 above, create new credentials if the Required Credentials checkbox was selected and you do not want to use an existing credential.
- Credential Name (required): The name to identify this credential with.
- User (required): Microsoft SQL Server username to connect with.
- Password (required): Microsoft SQL Server password to connect with.
- Use Azure Active Directory Password (optional): Azure Active Directory Authentication mechanism that allows connecting to Microsoft Azure SQL Database by using identities in Azure Active Directory. Additional information on Connect to Server

Figure 4
In Figure 4 above, use TEST CONNECTION button to check whether credentials are correctly configured and If ALL PASS, click CREATE.
Updated over 1 year ago