# Microsoft SQL Server

Integrate, catalog, and govern Microsoft SQL Server assets in Atlan. Optionally mine query history to build lineage.

## Required permissions

- [Preflight checks for Microsoft SQL Server](https://docs.atlan.com/llms/connectors/microsoft-sql-server/preflight-checks-for-microsoft-sql-server/llms.txt): Before running the Microsoft SQL Server crawler, you can run preflight checks to perform the necessary technical validations.

## Setup options

- [Set up Microsoft SQL Server](https://docs.atlan.com/llms/connectors/microsoft-sql-server/set-up-microsoft-sql-server/llms.txt): Configure authentication and permissions for Microsoft SQL Server to enable Atlan to crawl metadata from your database.
- [Choose how Atlan connects to SQL Server](https://docs.atlan.com/llms/connectors/microsoft-sql-server/choose-how-atlan-connects-to-microsoft-sql-server/llms.txt): Compare the three ways Atlan can reach your Microsoft SQL Server - direct with IP allowlisting, a private network link, or the self-deployed runtime - and pick the right one before you touch any firewall.
- [Connect directly with IP allowlisting](https://docs.atlan.com/llms/connectors/microsoft-sql-server/connect-directly-with-ip-allowlisting/llms.txt): Connect Atlan to a SQL Server that is reachable from the internet - including Azure SQL Database with "Selected networks" enabled. Four phases, each labeled with who performs it.
- [Special cases](https://docs.atlan.com/llms/connectors/microsoft-sql-server/special-cases/llms.txt): On-premises SQL Server via the self-deployed runtime, Windows/NTLM and Entra ID authentication quirks, Azure SQL Managed Instance failover listeners, and estates with many environments and ports.

## Crawl and mine

- [Crawl Microsoft SQL Server](https://docs.atlan.com/llms/connectors/microsoft-sql-server/crawl-microsoft-sql-server/llms.txt): Crawl metadata from Microsoft SQL Server to catalog databases, schemas, tables, and views. Extract column details and enable data discovery, lineage tracking, and governance after configuring user permissions.
- [Mine Microsoft SQL Server](https://docs.atlan.com/llms/connectors/microsoft-sql-server/mine-microsoft-sql-server/llms.txt): Once you have crawled assets from Microsoft SQL Server, you can mine its query history to construct lineage.

## Reference

- [Private network links to Microsoft SQL Server](https://docs.atlan.com/llms/connectors/microsoft-sql-server/private-network-links-to-microsoft-sql-server/llms.txt): Connect Atlan to a SQL Server that has no public access, over AWS PrivateLink or Azure Private Link - one common five-phase pattern covering EC2, RDS, Azure VM, and Azure SQL Database / Managed Instance.
- [Set up a private network link to Microsoft SQL Server on Amazon EC2](https://docs.atlan.com/llms/connectors/microsoft-sql-server/set-up-a-private-network-link-to-microsoft-sql-server-on-amazon-ec2/llms.txt): :::warning Who can do this? You will need your AWS administrator to complete these tasks - you may not have access yourself.
- [Set up a private network link to Microsoft SQL Server on Amazon RDS](https://docs.atlan.com/llms/connectors/microsoft-sql-server/set-up-a-private-network-link-to-microsoft-sql-server-on-amazon-rds/llms.txt): :::warning Who can do this? You will need your AWS administrator to complete these tasks - you may not have access yourself.
- [Set up privatelink to Azure SQL Database](https://docs.atlan.com/llms/connectors/microsoft-sql-server/set-up-a-private-network-link-to-azure-sql-database/llms.txt): Set up Azure Private Link between Azure SQL Database (PaaS) and Atlan using cross-subscription private endpoint connectivity.
- [Set up private link to SQL Server on Azure Virtual Machine](https://docs.atlan.com/llms/connectors/microsoft-sql-server/set-up-a-private-network-link-to-sql-server-on-azure-virtual-machine/llms.txt): Set up Azure Private Link between SQL Server on an Azure Virtual Machine (IaaS) and Atlan using a Private Link Service and Internal Load Balancer.
- [How Atlan connects to Microsoft SQL Server](https://docs.atlan.com/llms/connectors/microsoft-sql-server/how-atlan-connects-to-microsoft-sql-server/llms.txt): Learn how Atlan connects to Microsoft SQL Server using direct connectivity or Self-deployed runtime while protecting your network and credentials.
- [How SQL Server connectivity works](https://docs.atlan.com/llms/connectors/microsoft-sql-server/how-sql-server-connectivity-works/llms.txt): A plain-language explanation of where Atlan's crawler actually runs, the three traffic paths to your SQL Server, and how authentication rides on top of the network path.
- [Firewalls and allowlists](https://docs.atlan.com/llms/connectors/microsoft-sql-server/firewalls-and-allowlists/llms.txt): SQL Server traffic from Atlan usually crosses several firewalls, owned by different teams. Every layer, which Atlan value belongs in each, and the mistakes that generate the most support tickets.
- [What does Atlan crawl from Microsoft SQL Server?](https://docs.atlan.com/llms/connectors/microsoft-sql-server/what-does-atlan-crawl-from-microsoft-sql-server/llms.txt): Atlan crawls and maps the following assets and properties from Microsoft SQL Server.
- [SQL Server package](https://docs.atlan.com/llms/connectors/microsoft-sql-server/package-reference/llms.txt): Programmatically crawl and manage Microsoft SQL Server assets in Atlan using the Python SDK (pyatlan). Reference for the SQL Server assets package.
- [Microsoft SQL Server assets app](https://docs.atlan.com/llms/connectors/microsoft-sql-server/microsoft-sql-server-sdk-references-app-reference/llms.txt): Learn how to crawl Microsoft SQL Server assets and publish them to Atlan for discovery.

## Troubleshooting

- [Troubleshooting SQL Server connectivity](https://docs.atlan.com/llms/connectors/microsoft-sql-server/troubleshooting-microsoft-sql-server-connectivity/llms.txt): Symptom-first troubleshooting for Microsoft SQL Server connectivity - HYT00 login timeouts, 08001 handshake resets, TCP failures and redirects, authentication errors, private link stalls, and agent hangs.