# Microsoft SQL Server (MS SQL)

Follow this guide to connect your Microsoft SQL Server to Actian AI Analyst and start building agents on top of your data.

To connect your Microsoft SQL Server database to Actian AI Analyst, you'll need to:

1. Create a **login and user** in your SQL Server.
2. Grant the necessary **read-only permissions**.
3. Allow **Actian AI Analyst's IP address** through your firewall or network rules.
4. Set up the connection in the **Actian AI Analyst interface**.

> ⚠️ **Actian AI Analyst's agents only run read-only queries** on your data. Write permissions are never used.

***

### 1. Create Login and User in SQL Server

You'll need to create a server-level login and a database-level user that Actian AI Analyst can use to connect. The following SQL script sets up a read-only user for Actian AI Analyst:

```sql
-- Replace placeholder values with your actual database, schema, and password.

-- Create server-level login
CREATE LOGIN analyst_login WITH PASSWORD = '<your_secure_password>';

-- Switch to your target database
USE YourDatabaseName;

-- Create a database-level user linked to the login
CREATE USER analyst_user FOR LOGIN analyst_login;

-- Grant read-only access to all tables
ALTER ROLE db_datareader ADD MEMBER analyst_user;

```

> ✅ The `db_datareader` role gives read-only access to **all current and future tables** in the database.

### 3. Allow Actian AI Analyst's IP Address

If your SQL Server is behind a firewall or uses network policies, make sure to allow inbound traffic from Actian AI Analyst's static IP:

```
34.77.172.158
```

> This is required for Actian AI Analyst's agents to access your database.

### 4. Set Up the Connection in Actian AI Analyst

1. Click **Connections → Plus button → Select MS SQL**.
2. Fill in the following details:
   * **Host**: your SQL Server address
   * **Port**: typically 1433
   * **Database name**: the one where `analyst_user` has access
   * **Username**: `analyst_login`
   * **Password**: the password you defined earlier
3. Test the connection and save.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.wobby.ai/connections/connect-a-data-source/microsoft-sql-server-ms-sql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.