SQL Server data source does not support named instances

Grafana
1

I have SQL Server Express and Grafana both installed on my local machine. The SQL server is accessible via “localhost\SqlExpress”. SQL Server Browser service is running.
When I use “Localhost\SqlExpress” in the “Host” field of the SQL Server data source, I get this error message “No instance matching ‘SQLEXPRESS’ returned from host ‘localhost’”.

Seems that SQL Server data source does not accept named instances and only relies on IP/Host! Is there a workaround for this?

2

You need to use the instance name with two backward slashes(\\) like this → localhost\\SqlExpress

3

It doesn’t work…

It throws up an error with url like ‘localhost\\sqlExpress’

4

Hi , Anyone able to sort out this issue. Even I tried giving double back slash before the instance name , it is not working yet.

5

Hi pavaniperla,
i have same proble and didn’t solve.

6

Connect your instance via tcp port: sqlserver:port

To figure out your tcp port execute following sql in master database
xp_readerrorlog 0, 1, N'Server is listening on

7

Hello. I’m new to Grafana. Trying to plug ms sql datasource but facing same issue discussed above and in many other threads: Can’t figure out how to setup a named instance like XXXXX\SQLEXPRESS
I’m using v9.3.2 and whatever i tried in Host field ends with this kind of log:
logger=tsdb.mssql t=2023-01-10T09:21:16.9057758+01:00 level=error msg=“Query error” error=“Unable to open tcp connection with host ‘127.0.0.1:1433’: dial tcp 127.0.0.1:1433: connectex: No connection could be made because the target machine actively refused it.”
or
Unable to open tcp connection with host ‘localhost:1433’
or
Unable to open tcp connection with host ‘XXXXX:1433’
…

Please note that xp_readerrorlog does not return a line about the port being used

8

Edit: Also note that if I setup a default sqlserver instance (non named) then it is working with host like localhost:1433, but I want to target the named one, with a slash in the name…

9

Hello. I’m also facing the same issue. The error states: no instance matching ‘XXXX’ returned from host ‘XXXXX’ and I doubled check my firewall and checked that the listen port is 1433. I can’t seem to resolve this