# Need Help Configuring SQL Server Database Connection in Grafana

**URL:** <https://community.grafana.com/t/need-help-configuring-sql-server-database-connection-in-grafana/125848>\
**Category:** MSSQL\
**Tags:** sql\
**Created:** [July 9, 2024, 5:34pm UTC](https://community.grafana.com/t/need-help-configuring-sql-server-database-connection-in-grafana/125848 "2024-07-09T17:34:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tspreier](https://avatars.discourse-cdn.com/v4/letter/t/85f322/32.png) [@tspreier](https://community.grafana.com/u/tspreier)\
**Post date:** [July 9, 2024, 5:34pm UTC](https://community.grafana.com/t/need-help-configuring-sql-server-database-connection-in-grafana/125848/1 "2024-07-09T17:34:12Z")

</div>

Hello Community,

I have installed Grafana locally on my Windows Server 2022 using the following link:

> **[Download Grafana | Grafana Labs](https://grafana.com/grafana/download)**
>
> Overview of how to download and install different versions of Grafana on different operating systems.

After the installation, I logged into the web interface and tried to add my database connection. However, I am only getting error messages.

Here are the details of my database configuration:

- **Type:** Microsoft SQL Server
- **Host:** IP Address
- **Database:** Database Name
- **TLS/SSL Auth:** false
- **Authentication:** SQL Server Authentication
- **Username:** Grafana
- **Password:** password

I have left all other settings as default.

The user has the following permissions:

- `VIEW SERVER STATE`
- `VIEW ANY DEFINITION`

The database is configured to allow both SQL Server and Windows Authentication modes.

Except for the user permissions, all settings correspond to the Windows default settings.

I would appreciate your help with troubleshooting this issue!

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [July 9, 2024, 6:29pm UTC](https://community.grafana.com/t/need-help-configuring-sql-server-database-connection-in-grafana/125848/2 "2024-07-09T18:29:01Z")

</div>

> [@tspreier](#):
>
> The user has the following permissions:
> 
> - `VIEW SERVER STATE`
> - `VIEW ANY DEFINITION`

is this a global setting or specific to a database? have you given user grafana the following perms

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/4/5/45577a9bea0101e4b2ac3c87ab849011f54d58c7.png)