Skip to content

On-premise users: click in-app to access the full platform documentation for your version of DataRobot.

Data > Data connections > Supported connections > Microsoft SQL Server

Microsoft SQL Server

Supported authentication

  • Username/password

Prerequisites

The following is required before connecting to Microsoft SQL Server in DataRobot:

  • Microsoft SQL account

Required parameters

The table below lists the minimum required fields to establish a connection with Microsoft SQL Server:

Required field Description Documentation
address The service endpoint used to connect to SQL Server.

Example:
jdbc-cert-ms-sql-server-2016.cqz9ezetwbf4.us-east-1.rds.amazonaws.com:1489		 Microsoft documentation

Troubleshooting

Problem Solution Instructions
When attempting to execute an operation in DataRobot, the firewall requests that you clear the IP address each time. Add all allowed IPs for DataRobot. See Allowed source IP addresses. If you've already added the allowed IPs, check the existing IPs for completeness.
Updated February 1, 2024