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

# Microsoft SQL Server

> Microsoft SQL Server is a relational database management system developed by Microsoft.

# Overview

Microsoft SQL Server is a robust relational database management system that enables secure and efficient data management. Datazone provides native integration with SQL Server to read data directly from your databases.

## Connection Parameters

| Parameter     | Required | Description                                                    |
| ------------- | -------- | -------------------------------------------------------------- |
| Name          | Yes      | A unique identifier for your SQL Server source                 |
| Host          | Yes      | The hostname or IP address of your SQL Server instance         |
| Port          | Yes      | The port number on which SQL Server is running (default: 1433) |
| Database Name | Yes      | The name of the database you want to connect to                |
| Schema Name   | No       | Optional schema name (default schema is 'dbo')                 |
| User          | Yes      | Username with appropriate permissions to access the database   |
| Password      | Yes      | Password for the specified user                                |

## Required Permissions

The SQL Server user account needs the following permissions:

* `SELECT` - For reading data from tables and views
* `VIEW DEFINITION` - For accessing object metadata
* `VIEW DATABASE STATE` - For viewing database state information
* `CONNECT` - For connecting to the database

## Limitations

Be aware of the following limitations when working with SQL Server sources:

* Some SQL Server-specific data types may be converted to standard formats
* CLR data types are not supported
* Individual query size and timeout limits apply
* Connection pooling settings may affect performance

## Next Steps

After configuring your SQL Server source:

1. Create extracts to specify which tables to ingest
2. Configure scheduling for recurring extracts
3. Integrate the source into your data pipelines

For more information about working with extracts and pipelines, refer to their respective documentation sections.