Skip to content

Microsoft SQL Connection

To connect your Microsoft SQL database with Connect iPaaS, you have to provide the details of your Microsoft SQL server so that Connect iPaaS has required credentials to connect with the database and perform the desired actions.

We at RoboMQ pay utmost attention to keep your account secure. See our Security and Privacy Policy to learn more about how RoboMQ handles your account access.

Microsoft SQL Connection

Figure 1. Microsoft SQL Connection

Connect iPaas requires following details in order to connect to Microsoft SQL database.

Parameter Details
Connection Name Name of your connection. This is used by Connect iPaaS to identify your connection. The default name is "Connection-DatabaseAuth". You can give any other name.
Hostname The location of your Microsoft SQL server. It will generally be the IP address of your Microsoft SQL server or a URL pointing to the location of your Microsoft SQL sever.
Port The TCP/IP port on which the Microsoft SQL server is listening. The default port number is 1433. If your Microsoft SQL server uses a different port number to connect, reach out to RoboMQ support
Database Name The name of the target database where you want to perform the operations.
Username Username of the database user with required permissions to perform operations.
Password Password of the database user with required permissions to perform operations.

The database user must have the following permissions to carry out these operations:

Action Permission

Note: Connect iPaaS will not be able to connect to your database if it is protected by a firewall. For making your integration with Microsoft SQL work, whitelist these IP addresses on your server.