MSSQL Connecting to database timeout error

Grafana MSSQL
1

What Grafana version and what operating system I am using?
Windows 10 & Grafana Version 9.3.6

What am I trying to achieve?
Tring to connect mssql database.
This is a on-premise sql server. and i connecting this sql server remotely, which mean this db is not hosted in my pc.

How are you trying to achieve it?
there is some issue of this server, we will always need to increase the timeout to 60second while connecting this db.
I am trying to connect this db on datasource configuration. I increased the timeout to above 1 minute.

  • What happened?
    No matter what number i fill in the input section of connection timeout, the result always 15 seconds timeout. (from Grafana log details)

Please refer to the following picture, in this case i changed the timeout to above 1 minute, it’s still unable to connect to database. I checked the log details. the timeout only 15 seconds which is not matched to what I set.

grafana_mssql_error
grafana_mssql_error1647×1002 59.9 KB

timeout_Log
timeout_Log1712×67 11.3 KB

2

you have windows authentication. which user are you using to connect to mssql ?

3

Yea window authentication. It is based on window log in user. So we no need to input username and password. It is common practice of window authentication. The problem is I increase the timeout to 100 second but end up it is still maintained 15 seconds timeout . That why the connection failed.
Seen like the default connection timeout to database is 15second.

4

Temporarily try a sql login and see if it times out or not

5

this is equipment database. this db is hosted in server in our server room. I am not the server admin, i am only the database level admin. we are only allowed to connect to any application via Window Authentication. I just want to know how to increase connection timeout to database. it looks like the connection timeout input doesn’t work for it.

Any other method to increase timeout even from the source code. i am using open source version. Thank you very much

6

the issue might not be a timeout issue. How and where have you configured the windows authentication?

image
image730×73 7.64 KB

7

image
image1473×923 57.3 KB

I just choose window authentication from sql server data source screen.
I am pretty sure that this db can’t connect due to db connect time-out.

Grafana Log path: C:\Program Files\GrafanaLabs\grafana\data\log

image
image1697×198 38.9 KB

As I said previously, it always takes about a minute for the db connection to be established.
it is same to how i connect this db via SSMS: increase the timeout.

But you can see from my second screenshot, the connection duration only 15.007sec even i set it to 100 second which is not matched.

8

so you have single sign on windows users? and all users have permission to the db?

9

yes i have the permission to the db. This is how i connect this instance. normally i will set connection time-out to 120 second.

image
image704×390 14.1 KB

image

But in Grafana, it’s looks like can’t increase the timeout. it will always maintain 15 second timeout even i set it to 100 second.

10

Is your grafana configured for single sign on?

11

No… no SSO, i am using default admin account for grafana

12

you cannot use that see the documentation

image
image730×73 7.64 KB

13

image
image464×648 22.9 KB

This is another server, seen it can connect via window authentication.
I am very sure the problem come from connection timeout. I just want to extend the connection timeout… above 15 second.

1 Like
14

Any solution for this?

15

I would say improve the query? can you show the query that take more than 15s

16

That is no the query, that is the database connection, I not even can connect my database using Grafana

1 Like