---
title: "Creating a Microsoft SQL Device"
slug: "creating-a-microsoft-sql-device"
updated: 2024-09-23T16:55:21Z
published: 2024-09-23T16:55:21Z
canonical: "docs.ai-op.com/creating-a-microsoft-sql-device"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ai-op.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating a Microsoft SQL Device

After [creating a device](/v1/docs/adding-a-device-general) and selecting the Microsoft SQL protocol, you will be expected to fill out the following fields:

![](https://cdn.document360.io/9fab5c8f-2756-48da-b963-232bd8533649/Images/Documentation/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](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.

> [!WARNING]
> 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.

> [!WARNING]
> 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*](https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user)

#### Password

The password associated with the username.

> [!NOTE]
> 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.