Grafana V8.1 error connect to Localhost MSSQL 2019 Ver 15.0.2000

Grafana MSSQL
3

Hi T_Grumpy,

curently my problem was solved. please see my step:

  1. Open the microsoft sql server studio, right click the database properties and check the option sql server windows authentication mode

    database properties
    database properties472×902 26.2 KB

    database security properties
    database security properties1047×1013 34.5 KB

  2. Open sql server configuration manager, click Sql server network configuration → protocols for SQLEXPRESS01, then enable the TCP/IP

    sql configuration manager
    sql configuration manager1179×857 63.7 KB

  3. after enable TCP/IP, re-right click the properties as green box to set the port 1433 to IPALL and then OK

    TCPIP IPALL port
    TCPIP IPALL port516×570 48.8 KB

  4. Open the firewall port for TCP and UDP to 1433. create new inbound rule for port 1433, select TCP and OK. then recreate for UDP also in same port 1433.

    port sql
    port sql1743×570 96.8 KB

  5. insert your DB confguration into grafada.

    grafana_sql
    grafana_sql1219×662 43 KB

1 Like