Microsoft SQL Server

This guide helps you connect your Microsoft SQL Server database to Neo by walking through the required connection details and authentication options.

Getting Started

To connect to a MsSQL database, you’ll need:

  • Basic connection details like host, port, database, and schema

  • One of two authentication options:

    • Standard Authentication (username & password)

    • SSL Authentication (certificates)

Connection Details

Here’s what each field means and how to fill it out:

1. Name

A unique name to identify your MsSQL connection.

This is how you’ll recognize the source later when managing multiple sources.

Example:

  • mssql-prod

  • reporting-db

  • team-hr-mssql

This name must be unique across all your sources.

2. Host

Provide the hostname or IP address of your MsSQL server.

Example: mssql.internal.company.com or 172.16.1.10

3. Port

The port used to connect to the server.

Default is 1433 — change it only if your server uses a different port.

4. Database

Provide the name of the database you want to connect to.

Example: sales_reporting, user_data

5. Schema

Specify the schema within your database where your tables reside.

By default, this is set to dbo.

Authentication Options

Choose between:

  • Standard Auth – good for simple setups

  • SSL Auth – recommended for secure and production environments

Option 1: Standard Authentication

Use this if your MsSQL server uses a username and password to log in.

You’ll need:

Username:

Your MsSQL username.

Example: readonly_user

Password:

Corresponding password.

This will be securely masked in the UI.

Option 2: SSL Authentication

Choose this for a more secure, certificate-based connection.

You’ll need:

Username and Password:

Same as standard login.

SSL CA Certificate (ssl_ca):

The Certificate Authority file (ca.pem) that verifies the server.

SSL Client Certificate (ssl_cert):

Your public certificate (client-cert.pem) used to identify the client.

SSL Client Key (ssl_key):

The private key (client-key.pem) that matches the certificate.

All certificates should be in PEM format.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.