MSSQL DataSource using Windows integrated authentication cannot work

I tried to add MSSQL data source in Grafana and did choose Windows integrated authentication, but it didn’t work. In the MSSQL log, I found the login failed info, but it indicated the connection used SQL Server authentication rather than Windows integrated authentication. Per the doc, MSSQL data source can support Windows integrated authentication.

welcome @ef109539457

Can you try to see if the grafana service itself can run as that user name and password?

image

Thanks for your reply. In my case, Grafana service is running on Linux server and the service account is an domain account.

1 Like

for testing purposes, I would install grafana on a windows machine and run the grafana service using that domain/grafi user

And see what happens. Then we can walk our way back to Linux afterwards.