dulele created FLINK-40649:
------------------------------
Summary: [sqlserver-cdc] Agent status validation fails on
localized SQL Server instances where service name is not in English
Key: FLINK-40649
URL: https://issues.apache.org/jira/browse/FLINK-40649
Project: Flink
Issue Type: Bug
Components: Flink CDC
Reporter: dulele
* Flink CDC version: 3.x （main）
* SQL Server version: Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64)
Enterprise Edition
* OS: Windows Server 2016 Datacenter (Chinese Simplified)
* {*}Bug Description：{*}org.apache.flink.table.api.ValidationException: SQL
Server Agent is not running.
Please start SQL Server Agent before creating the SQL Server pipeline.
at
org.apache.flink.cdc.connectors.sqlserver.utils.SqlServerSchemaUtils.validateSqlServerAgentRunning(SqlServerSchemaUtils.java:78)
* *Root Cause Analysis*
{{{}SELECT TOP(1) status_desc FROM
sys.dm_server_services{}}}{{{}WHERE servicename LIKE 'SQL Server Agent (%'{}}}
{{ bug my sqlserver (SQL Server 代理 (MSSQLSERVER)) not }}{{{}SQL Server Agent
(%{}}}{{{}{}}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
