Documentation for automated readers
A curated documentation index is available at: https://grafana.com/llms.txt
A complete documentation index is available at: https://grafana.com/llms-full.txt
These indexes can help with page discovery before fetching individual documents.
This page is also available in Markdown, which may be easier for automated readers and AI tools to parse than HTML. The Markdown version is available at https://grafana.com/docs/grafana/latest/datasources/mssql.md, or by sending Accept: text/markdown to https://grafana.com/docs/grafana/latest/datasources/mssql/. For broader documentation discovery, the curated index is available at https://grafana.com/llms.txt and the complete index is available at https://grafana.com/llms-full.txt.
Microsoft SQL Server data source
Microsoft SQL Server (MSSQL) is one of the most widely used relational databases for business applications, analytics, and operational workloads. The built-in MSSQL data source lets you query your existing SQL Server instance directly from Grafana, no data migration or additional plugins required.
You can connect to Microsoft SQL Server 2012 or newer, Azure SQL Database, and Azure SQL Managed Instance.
Supported features
| Feature | Supported |
|---|---|
| Metrics | Yes |
| Alerting | Yes |
| Annotations | Yes |
Supported versions
| Version | Supported |
|---|---|
| Microsoft SQL Server 2012+ | Yes |
| Azure SQL Database | Yes |
| Azure SQL Managed Instance | Yes |
Grafana recommends using the latest available service pack for optimal compatibility.
Authentication methods
The Microsoft SQL Server data source supports the following authentication methods:
| Method | Best for | Grafana Cloud | Self-managed | Supports alerting |
|---|---|---|---|---|
| SQL Server Authentication | Any deployment | Yes | Yes | Yes |
| Windows Authentication (Integrated Security) | On-premises with Windows SSO | No | Yes | Yes |
| Windows AD (Kerberos) | Enterprise Active Directory environments | No | Yes | Yes |
| Azure Entra ID (App Registration) | Azure SQL with service principal | Yes | Yes | Yes |
| Azure Entra ID (Managed Identity) | Grafana hosted in Azure | No | Yes | Yes |
| Azure Entra ID (Current User) | User-level access control with Azure SQL | Yes | Yes | No |
Note
Azure Entra ID (Current User) authentication doesn’t support alerting, reporting, or recorded queries because these features run on the backend without a user session.
For configuration details, refer to Configure the Microsoft SQL Server data source.
Get started
The following documentation helps you set up and use the Microsoft SQL Server data source:
Additional features
After you configure the data source, you can:
- Use Explore to query data without building a dashboard
- Create visualizations including time series, tables, and gauges
- Add transformations to manipulate query results
- Optimize performance with query caching (Grafana Enterprise and Cloud)
Related data sources
Was this page helpful?
Related resources from Grafana Labs


