Creating an MS SQL Server connection

Changing connection ranges

When connecting to an external data source (that's not a Yandex.Cloud resource), grant access to the source for the DataLens IP address ranges.

Old ranges valid until December 1, 2020

• 77.88.39.88/29
• 93.158.158.96/29
• 93.158.156.80/29
• 77.88.39.224/28
• 37.9.126.112/28
• 37.9.65.32/28

Transition ranges from October 1 to December 1, 2020

During the transition period, add the new ranges to the current ranges. Starting from December 1, leave only the new ranges.

New ranges as of December 1, 2020

• 178.154.242.176/28
• 178.154.242.192/28
• 178.154.242.208/28
• 178.154.242.128/28
• 178.154.242.144/28
• 178.154.242.160/28

Connecting to MS SQL Server

To create an MS SQL Server connection:

1. Go to the connections page.
2. Click Create connection.
3. Select the MS SQL Server connector.
4. Specify the connection parameters:
   • Connection name. Specify a name for the connection. You can set any name.
   • Hostname or IP. Specify the path to the MS SQL Server host.
   • Port. Specify the MS SQL Server connection port.
   • Database name. Specify the name of the database to connect to.
   • Username. Specify the username for the MS SQL Server connection.
   • Password. Enter the password for the specified user.
5. Click Connect. The connection appears in the list.