After creating a device and selecting the Microsoft SQL protocol, you will be expected to fill out the following fields:
.png "image(40).png")
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.