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

# Microsoft SQLをナレッジベースに接続する

> SQL Server データベースに接続して、AI エージェントがデータにアクセスできるようにします。

Microsoft SQL コネクタを使用すると、SQL Server データベースをナレッジ ベースに直接接続できます。接続すると、EKB は指定したテーブルにインデックスを作成し、データベースのコンテンツを検索可能にし、AI エージェントがアクセスできるようにして、根拠のあるデータ駆動型の応答を実現します。

## Microsoft SQL への接続

<Steps>
  <Step title="Open Project Settings">
    In your EKB project, navigate to **Settings** in the sidebar.
  </Step>

  <Step title="Go to Connections">
    Select the **Connections** tab and find the **Microsoft SQL** tile under **Databases**.
  </Step>

  <Step title="Open the Microsoft SQL popup">
    Click the **Microsoft SQL** tile. A popup appears with the option to connect to SQL Server databases. Click **+ Add Connection**.
  </Step>

  <Step title="Fill in the connection form">
    Enter the following details:

    **Server**

    | Field               | Required | Description                                                              |
    | ------------------- | -------- | ------------------------------------------------------------------------ |
    | **Connection Name** | Yes      | A display name for this connection (e.g. **PLACEHOLDER\_0**).            |
    | **Host**            | Yes      | The hostname or IP address of your SQL Server (e.g. **PLACEHOLDER\_1**). |
    | **Port**            | Yes      | The port your SQL Server is listening on. Default is **PLACEHOLDER\_2**. |

    **Authentication**

    | Field        | Required | Description                                    |
    | ------------ | -------- | ---------------------------------------------- |
    | **Username** | Yes      | The SQL Server user (e.g. **PLACEHOLDER\_3**). |
    | **Password** | Yes      | The password for the SQL Server user.          |

    **Database**

    | Field                   | Required | Description                                                             |
    | ----------------------- | -------- | ----------------------------------------------------------------------- |
    | **Database**            | Yes      | The name of the database to connect to (e.g. **PLACEHOLDER\_4**).       |
    | **Schema**              | Yes      | The schema to use (e.g. **PLACEHOLDER\_5**).                            |
    | **Tables**              | Yes      | The tables to index. Enter each table name separated by a comma.        |
    | **Always Trust Server** | No       | Enable this toggle to bypass SSL certificate validation for the server. |
  </Step>

  <Step title="Save the connection">
    Click **Save**. EKB will authenticate using the details provided. If successful, the **Microsoft SQL** tile on the Connections page will display a green dot and a count of your active Microsoft SQL connections.
  </Step>
</Steps>

<Check>You're now ready to use your Microsoft SQL data in the Knowledge Base!</Check>