Creating an MS SQL Server connection
Warning
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.
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:
- Go to the connections page.
- Click Create connection.
- Select the MS SQL Server connector.
- 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.
- Click Connect. The connection appears in the list.
Note
You can check the host connection before creating it. To do this, click Check connection.