Creating a Microsoft SQL Device

After creating a device with the Microsoft SQL protocol, you'll land on its Configuration tab. This is where you provide the connection details Koios needs to query your SQL Server database.

Configuration Fields

Database Driver

The ODBC driver used to connect to SQL Server. Select the driver that matches what's installed on the Koios server.

• Required

Hostname / Server

The hostname or IP address of the SQL Server instance.

• Required
• Example: 192.168.1.100 or sqlserver.local

Database Name

The name of the database to connect to on the SQL Server instance.

• Required
• Example: mydb

Username

The SQL Server login used to authenticate.

• Required

Password

The password for the SQL Server login.

• Required

Timeout (seconds)

How long Koios waits for the database to respond before giving up.

• Default: 10 seconds
• Minimum: 1 second
• Maximum: 300 seconds (5 minutes)

Database queries may take longer than typical device reads, especially for complex queries or large datasets. The default of 10 seconds is appropriate for most use cases.

After Configuration

Once you've filled in the connection settings:

1. Save the configuration
2. Add tags — each tag defines a SQL query to execute (see Creating a Microsoft SQL Tag)
3. Enable the device — flip the enable switch to start querying