MSSQL Source: CDC Check fails on German SQL Server due to localized service name for SQL Server Agent

[dhegaplast]

Connector Name

[source-name] Microsoft SQL Server (MSSQL)

Connector Version

4.2.4

What step the error happened?

Configuring a new connector

Relevant information

During setup of a Source to a German Microsoft SQL Server, Airbyte executes the following SQL to check if the SQL Server Agent is running:

SELECT status_desc
FROM sys.dm_server_services
WHERE servicename LIKE 'SQL Server Agent%'

However, on German installations, the service name is localized and starts with "SQL Server-Agent" (note the extra hyphen and the German spelling).

Suggestion:
To make this check language-independent, please use:

SELECT status_desc
FROM sys.dm_server_services
WHERE servicename LIKE '%Agent%'

This will match both English and localized service names (e.g., "SQL Server Agent" and "SQL Server-Agent").

Thanks for considering this improvement!

Relevant log output

Contribute

• Yes, I want to contribute