June 19, 2009 at 9:20 pm
I am running into a replication issue I just cannot seem to crack. The replication is setup between two systems connected through a VPN. The replication server is a Windows 2008 SP 1 server running SQL Server 2008, it is setup as both the publisher and the distributor and is apart of an Active Directory domain. The subscriber is an XP SP2 system with MSDE SP4 installed on it and is in workgroup. The VPN connection is setup between two routers, one at each location.
I can and have been able to apply the initial snapshot to the subscriber but when making changes to the subscriber changes do not replicate. I looked in the replication monitor of the 2008 server and the Queue Agent Reader has an error stating "The replication agent has not logged a progress message in 10 minutes. " etc... The following are some of the steps I have tried to resolve the issue (not necessarily in any specific order):
1. I have downloaded and used the DTCPing utility. I am able to ping from the SQL Server to the MSDE system but have not been able to ping in the other direction.
2. I have disabled the software firewalls on both systems, as well as the firewalls inside each router and nothing changes.
3. Defined a replication user and set both the Distributed Transaction Coordinator and the SQL Agent service to log on as that user on both systems. The user is defined as a system administrator on the XP system and a Domain Admin in the Active Directory environment of the SQL Server with full rights to the server I am dealing with.
The following is a portion of the log from the DTCPing tool when ran from the subscriber:
++++++++++++hosts ++++++++++++
127.0.0.1 localhost
192.168.0.23SQLSERVER
++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for SQLSUBSCRIBER
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
06-19, 21:56:50.593-->Start DTC connection test
Name Resolution:
SQLSERVER-->192.168.0.23-->SQLSERVER
06-19, 21:56:50.656-->Start RPC test (SQLSUBSCRIBER-->SQLSERVER)
RPC test failed
And a partial log from the server:
++++++++++++hosts ++++++++++++
127.0.0.1 localhost
::1 localhost
192.168.1.100SQLSUBSCRIBER
06-19, 21:42:31.325-->Error(0x424) at clutil.cpp @256
06-19, 21:42:31.325-->-->OpenCluster
06-19, 21:42:31.338-->-->1060(The specified service does not exist as an installed service.)
++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for SQLSERVER
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
06-19, 21:43:07.848-->RPC server:SQLSERVER received following information:
Network Name: SQLSERVER
Source Port: 14461
Partner LOG: SQLSUBSCRIBER3196.log
Partner CID: DF72F352-7C37-4F28-BB74-021F4397C9A3
++++++++++++Validating Remote Computer Name++++++++++++
06-19, 21:58:04.820-->Start DTC connection test
Name Resolution:
SQLSUBSCRIBER-->192.168.1.100-->SQLSUBSCRIBER
06-19, 21:58:04.862-->Start RPC test (SQLSERVER-->cdt003a)
RPC test is successful
Partner's CID:DF72F352-7C37-4F28-BB74-021F4397C9A3
++++++++++++RPC test completed+++++++++++++++
I am thinking that I am running into an authentication issue but have tried (and obviously failed) some settings in Active Directory, and have also changed some settings with DCOM. Any direction/ideas would be greatly appreciated and thanks in advance.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply