Transactional Replication with Queued updating | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transactional Replication with Queued updating

I’m trying to do replication(tarnsactional replication with queued updating) on two different servers(SQL server 2000) one of them is configured as Publisher and Distributer whereas other one is a subscriber. Everything seems fine but only problem is that modifications made to the articles from the subscribers are not being updated on the publisher.The transactions from publisher to the subscriber works fine.I tried ODBCping from publisher which gives the output as follows: CONNECTED TO SQL SERVER ODBC SQL Server Driver Version: 03.80.0194 SQL Server Version: Microsoft SQL Server 2000 – 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) But when I tried same thing from subscriber to the publisher the output was as follows: C:program FilesMicrosoft SQL ServerMSSQLBinn>odbcping -S -U sa
-P COULD NOT CONNECT TO SQL SERVER SQLState: 28000 Native Error: 18456
Info. Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for u
ser ‘sa-P’. Can anyone solve this problem , it’s very urgent. Regards

I’ve found that when odbcping command was given without -P the subscriber server got connected to the publisher server.
However the problem still persists,i.e. the chenges made to the article at subscriber end doesn’t get updated at the publisher end. Queued reader agent error :"Server: ABC, Database unique : ODBC Error:Could not change the Publisher because the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggers."
Any clue on this?

ENsure similar levels of MDAC and service pack levels are used between the SQL Servers.
Check link that explains the workout about login failures. KBA;en-us;320773 too. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.