大网数据广告活动
数据库与应用安全

Pull subscriptions do not show up in Windows Synchronization Manager

· 52CE 我爱测

This article provides a workaround for the problem that pull subscriptions are not displaying in Windows Synchronization Manager.

Applies to:   SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014

Symptoms

Assume that you create a pull subscription to a merge publication. After enabling the synchronization with Windows Synchronization Manager, there's no subscription listed in the Sync Center (mobsync.exe) of the subscriber.

Workaround

Note: This workaround applies only to SQL Servers with a single instance.

Important: Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration.

Here's how to work around this issue:

  1. In the search box on the taskbar, type regedit, then select Registry Editor (Desktop app) from the results to open Registry Editor in Windows 10.

  2. Locate and select the registry subkey: HKLM\Software\Microsoft\Windows\CurrentVersion\SyncMgr\Handlers\{FFAADE58-9A14-45F3-A497-E969A64F09C7}.

  3. Rename the subkey name depending on the SQL Server version as follows:

    SQL Server Version Registry Handler Value
    SQL Server 2014 D6133761-E626-4DF7-90F6-7DDD8FCCB926
    SQL Server 2016 E828F4BF-6E5C-4549-A3BA-CF53F6A60819
    SQL Server 2017 C96C286D-DFC0-4CF0-9CF8-7D582094D263
    SQL Server 2019 B1544C19-71BD-417C-8DE2-430A0CDCEA06

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors (upstream author metadata: aartig13). Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/26/2021
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。