[[inputs.sqlserver]] protocol other than TCP does not work

varakspavel · August 28, 2025, 4:42pm

config:
[[inputs.sqlserver]]
servers = [
“Server=Localhost;Integrated Security=SSPI;app name=telegraf;protocol=lpc;log=1”

Errors:
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerVolumeSpace failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerPerformanceCounters failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerAvailabilityReplicaStates failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerMemoryClerks failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerPersistentVersionStore failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerDatabaseReplicaStates failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerProperties failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerDatabaseIO failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerCpu failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’
2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerWaitStatsCategorized failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: ‘lpc’

but after change protocol instead lpc on tcp everything works, but need connect to SQL Server with SharedMemory, without TCP.
Driver go-mssqldb supports this.

Addition Information: telegraf v1.35.4, Windows Server 2022, SQL Server 2019

srebhan · August 29, 2025, 9:00am

Please open an issue! We need to import more packages it seems…

varakspavel · August 29, 2025, 11:14am

Thanks for the info. I opened a issue.

github.com/influxdata/telegraf

[inputs.sqlserver] support parameter protocol in go-mssqldb

opened 07:18PM - 28 Aug 25 UTC

varakspavel

feature request

### Use Case Now Telegraf can only connect to MSSQL via **TCP**. Sometimes it i…s necessary to disable **TCP** and use only SharedMemory(Local Procedure Call (LPC)). And additionally, after the August Windows OS updates, Telegraf stopped working if **TLS+EP (Channel Binding)** is enabled ### Expected behavior The telegraf can be connected to **MSSQL** via the **LPC** protocol and **NP**(Named Pipes). ### Actual behavior When trying to add a parameter **protocol** with a value different from **tcp**. Example: > [[inputs.sqlserver]] > servers = [ > "Server=Localhost;Integrated Security=SSPI;app name=telegraf;protocol=lpc;log=1" An error occurs: _2025-08-28T16:23:40Z E! [inputs.sqlserver] Error in plugin: query SQLServerPersistentVersionStore failed for server: LOCALHOST and database: with Error: No protocol handler is available for protocol: 'lpc'_ ### Additional info https://github.com/microsoft/go-mssqldb?tab=readme-ov-file#protocol-configuration

varakspavel · October 27, 2025, 12:01pm

srebhan, hi

When can you implement this feature or fix the bug?

I’m really looking forward to the solution, thank you

Topic		Replies	Views
E! Error in plugin [inputs.sqlserver]: existing connection was forcibly closed by the remote host Telegraf telegraf	3	1277	March 27, 2020
Having Problems with MSSQL Plugins for Telegraf Telegraf	2	647	October 12, 2022
Error in inputs.sql.query getting metrics from sqlserver - One database multiple instances - InfluxDB 2	7	2256	June 4, 2020
Telegraf SQL Server Plugin Issue with Windows Authentication Telegraf	3	4021	September 3, 2018
Not getting data for "Memory Clerk", "Database size", "Database latency" , "OS Volume", "CPU" in SQL server using telegraf Telegraf telegraf	3	738	May 28, 2019

[[inputs.sqlserver]] protocol other than TCP does not work

Related topics