Error connecting to MSSQL data source

Grafana MSSQL
1

Grafana v10.3.3 (252761264e) Windows

  • What are you trying to achieve?
    Add a MSSQL Data Source

  • How are you trying to achieve it?
    Add new data source

  • What happened?
    It says failed to connect to server

    Capture2
    Capture21053×90 5.92 KB

  • What did you expect to happen?
    Data source added

  • Can you copy/paste the configuration(s) that you are having problems with?
    Capture3
    Capture4

    Capture6
    Capture61060×522 30.8 KB

2

Probably best not to use sa.
Create a swlmuser called grafana give it real only perms to db, or add it to a read only group.

Sql auth is inherently weak, suggest you use a real ad user.

4

Still cannot connect

5

Check this

6

ss

ss1

ss2

ss3

still cannot connect

7

this might help

https://knowledgebase.apexsql.com/configure-remote-access-connect-remote-sql-server-instance-apexsql-tools/

so basically your issue is really not grafana issue it is a network connection issue to a sql server instance, multiple factors that you need to sort out on the SQL side.

also could be you need a comma before the port instead of colon :

ip\instance,port

Also always restart sql server service for the specific instance (careful not restart other instances) for changes to take full effect