SQL Exporter Failing to Connect to SQL Server Named Instance

[aszkuat]

We are experiencing persistent issues with the SQL Exporter failing to gather metrics from our SQL Server named instance. Despite multiple attempts to configure the data source name correctly, the exporter either times out or returns errors indicating invalid URL escape sequences.
Environment:

SQL Exporter version: 0.14.3
SQL Server instance:
server01.domain.local\instance1
server01.domain.local\instance2
Authentication: SQL authentication using username and password

We use dynamic ports for MS SQL.

Tried different formats for the data source name:
data_source_name: sqlserver://username:[email protected]?database=instance1&encrypt=false&trustServerCertificate=true
data_source_name: 'sqlserver://username:[email protected]\instance1'
data_source_name: 'sqlserver://username:[email protected]\instance1'

What should the data source field look like when not using static ports?

[burningalchemist]

Hi @aszkuat, sql_exporter is using dburl library for unified DSN connection string format across many databases, so I'd suggest to try this syntax out as per their documentation:

sqlserver://user:[email protected]/instance/dbname

where instance is instance1 and dbname is your desired database name to connect to. dbname might also be a mandatory value (whereas instance can be optional), but it's controlled by the mssql driver, so omitting might potentially work. Give it a try.

Here is the reference link.

Also, the reference from the driver here.

[aszkuat]

Thank you, the option works.