Issue connection with database

Grafana MSSQL
1

  • What Grafana version and what operating system are you using?
    10.2.2

  • What are you trying to achieve?
    Get data from database

  • How are you trying to achieve it?
    I connected the MSSQL to Grafana, but for some reason when I select the database, I am not able to acess to the tables on it.

  • What happened?
    For some reason I am not able to get the tables in the database, I thought that was a problem with the permits in the database. I gave the permits to the user, but it not works.

  • What did you expect to happen?
    I expected that was the permits on MSSQL.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    I did not receive any error.

  • Did you follow any online instructions? If so, what is the URL?
    Microsoft SQL Server data source | Grafana documentation

    Tables result
    Tables result1658×838 61.9 KB

    DB Connection
    DB Connection1915×965 69.8 KB

2

Welcome @jlara

Does the user you used to create the data source have access to the database and tables?

3

Hello @yosiasz, thank you. Yes, the user has access to the databases, tables and I am able to enter directly to MSSQL, but for some reason when I tried to get data using Grafana just show me only tables, I was using windows authentication mode.

Other option that works for me was using a SQL login, and it works, I did not understand if there are action that skipped by my side, but I am still investigation.

Thank you for the attention.

1 Like