![]() # Use either URL or the previous fields to configure the database ![]() # If the password contains # or you have to wrap it with triple quotes. # Either "mysql", "postgres" or "sqlite3", it's your choice # as separate properties or as on string using the url property. # You can configure the database connection by specifying type, host, name, user and password The default DB configuration in Grafana conf file is: ![]() Do I need to change the default conf or create another conf file? I should mention that, I haven't changed Grafana conf file. How can I force SQL server to give access to Grafana? ![]() 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 :1433: connectex: No connection could be made because the target machine actively refused it." 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 created a user in SQL server and granted reader permission to the user as per. In Grafana, I selected SQL Server data source and provided Host and DB name. I run both Grafana and SQL server on the same machine with Windows OS. I'm new to Grafana and trying to connect Grafana to Microsoft SQL Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |