添加链接
link之家
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接
相关文章推荐
好帅的冲锋衣  ·  利用Image ...·  4 月前    · 
失落的啄木鸟  ·  PyPDF2.errors.Deprecat ...·  8 月前    · 
Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

db query error: failed to connect to server - please inspect Grafana server log for details

Ask Question

I'm new to Grafana and trying to connect Grafana to Microsoft SQL Server. I run both Grafana and SQL server on the same machine with Windows OS. In Grafana, I selected SQL Server data source and provided Host and DB name. I created a user in SQL server and granted reader permission to the user as per https://grafana.com/docs/grafana/latest/datasources/mssql/ . Either for SQL server Authentication or Windows Authentication, I get the error db query error: failed to connect to server - please inspect Grafana server log for details . I checked then Grafana log file: lvl=eror msg="query error" logger=tsdb.mssql err="Unable to open tcp connection with host 'servername:1433': dial tcp [2a02:908:1391:9e80:c180:xxxx:xxxx:xxxx]:1433: connectex: No connection could be made because the target machine actively refused it." How can I force SQL server to give access to Grafana?

I should mention that, I haven't changed Grafana conf file. Do I need to change the default conf or create another conf file? The default DB configuration in Grafana conf file is:

[database]
# You can configure the database connection by specifying type, host, name, user and password
# as separate properties or as on string using the url property.
# Either "mysql", "postgres" or "sqlite3", it's your choice
type = sqlite3
host = 127.0.0.1:3306
name = grafana
user = root
# If the password contains # or ; you have to wrap it with triple quotes. Ex """#password;"""
password =
# Use either URL or the previous fields to configure the database
# Example: mysql://user:secret@host:port/database
url =
# Max idle conn setting default is 2
max_idle_conn = 2
# Max conn setting default is 0 (mean not set)
max_open_conn =
# Connection Max Lifetime default is 14400 (means 14400 seconds or 4 hours)
conn_max_lifetime = 14400
# Set to true to log the sql calls and execution times.
log_queries =
# For "postgres", use either "disable", "require" or "verify-full"
# For "mysql", use either "true", "false", or "skip-verify".
ssl_mode = disable
# Database drivers may support different transaction isolation levels.
# Currently, only "mysql" driver supports isolation levels.
# If the value is empty - driver's default isolation level is applied.
# For "mysql" use "READ-UNCOMMITTED", "READ-COMMITTED", "REPEATABLE-READ" or "SERIALIZABLE".
isolation_level =
ca_cert_path =
client_key_path =
client_cert_path =
server_cert_name =
# For "sqlite3" only, path relative to data_path setting
path = grafana.db
# For "sqlite3" only. cache mode setting used for connecting to the database
cache_mode = private
                What server are you actually using? type=sqlite3 is for SQLite file-based databases, host=127.0.0.1:3306 is MySQL's default port, yet your error message mentions servername:1433.
– AlwaysLearning
                Aug 26, 2021 at 12:42
                Your Grafana can't open TCP connection - so something is blocking it on the network level (probably Windows firewall).
– Jan Garaj
                Aug 26, 2021 at 13:35
                I enabled TCP/IP connection in SQL Server Configureation Manager. Still I get the same error.
– Yasi
                Aug 27, 2021 at 11:34

The settings in Grafana's configuration file refer to its internal database so you do not need to change any of these to connect to MS SQL Server.

  • Try using "localhost" or "127.0.0.1" as the host name
  • Make sure authentication is SQL Server Authentication
  • Make sure Encrypt is false
  • Check the SQL server logs for any errors
  • IPCONFIG /ALL
  • Look for the IPV4 address under WiFi or vEtherner; in my case, it's 192.168.1.24 and 172.45.202.1, respectively
  • Then try accessing the app hosted in the Docker container with the mapped port (e.g., 1433/5436)
  • It simply worked using 192.168.1.24:1433 and 172.45.202.1:1433 in the same way to access all container apps hosted using Docker
  • Thanks for contributing an answer to Stack Overflow!

    • Please be sure to answer the question. Provide details and share your research!

    But avoid

    • Asking for help, clarification, or responding to other answers.
    • Making statements based on opinion; back them up with references or personal experience.

    To learn more, see our tips on writing great answers.