Article ID: 292442
Article Last Modified on 10/31/2003
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q292442
SUMMARY
If you have Microsoft Windows 2000 or Microsoft Internet Explorer 5.0, Pull subscribers can use the Windows Synchronization Manager (WSM) to synchronize with the publisher.
This article documents the registry keys that are used by WSM. If the WSM is not able to open the properties of a subscription, or to synchronize with the publisher, check the registry keys documented in this article and the permissions to the key.
MORE INFORMATION
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
The Synchronization Manager uses the following key to get a list of items to display (for example, Microsoft SQL Server 2000):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Syncmgr\Handlers
The preceding key has a subfolder for each item based on the class id (clsid).
To determine what to call when synchronization is invoked, the Synchronization Manager uses this registry key:
HKEY_CLASSES_ROOT\CLSID\number\Inprocserver32
For example:
HKEY_CLASSES_ROOT\CLSID\{08B0B2D5-3FB3-11D3-A4DE-00C04F610189}\inprocserver32
For SQL Server 2000 the value is:
"C:\Program Files\Microsoft SQL Server\80\COM\Replsync.dll"
For SQL Server 7.0 the value is:
"C:\Mssql7\Binn\Replsync.dll"
The examples assume that SQL Server is installed on the C: drive.
Replysnc.dll is the SQL Server Replication Synchronization Manager Handler.
The registry key for the list of subscriptions is:
'SQL Server 2000'
HKLM\Software\Microsoft\Microsoft SQL Server\80\Replication\Subscriptions
'SQL Server 7.0'
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Replication\Subscriptions
There is a subfolder for each publication to which the client is subscribed . When you use Synchronization to view properties, Synchronization accesses the preceding keys to obtain all the values.
When the Synchronization Manager invokes the synchronization process, the progress status messages are controlled by these keys:
'SQL Server 2000'
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Replication
'SQL Server 7.0'
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLEW\Replication
Keywords: kbinfo KB292442
