Creating a Microsoft SQL Device

After creating a device and selecting the Microsoft SQL protocol, you will be expected to fill out the following fields:

Driver Name

Select the ODBC driver compatible with your version of Microsoft SQL. For a detailed compatibility matrix, visit: https://learn.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-ver16&viewFallbackFrom=sql-server-ver1

Server Hostname

The IP address or hostname of the server.

Port Number

Do not supply a port number at the end of the IP address, The OBDC Driver accesses it's own port for connections. (i.e. 192.168.1.22)

Database Name

The name of the database you would like to connect to.

Username

The username you would like to authenticate with.

Windows User

You cannot use Windows Authentication to connect to a database using Koios. If you need to create a new user, refer to: How to Create a SQL Database User

Password

The password associated with the username.

Expired

If your password has expired, please sign into your management software and update the password from there. You are unable to do so from Koios.

Timeout

The amount of time in seconds Koios will wait for a response before it considers the connection to the device as failed.