Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Problem with updating data on subscribers

Author  Topic 

hendrasd
Starting Member

20 Posts

Posted - 2003-03-30 : 03:22:07
I set up a transactional replication with updateable subscription using immediate updating. Server A act as Publisher, Server B act as subscriber. Subscription type is Push subscription. It seems fine when I edited (inserted, deleted, updated) data in table X on Publisher, the results of data editing can be viewed on table X on Subscriber. But when I tried to edit data in table X on Subscriber, the following error message showned : 'Login failed for sa'. So, I wonder what would be the cause of the error and how to work around the problem. FYI : I use same password for sa for both server. Thanks for your help.

-- Never stop learning --

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2003-03-30 : 15:53:35
See if this helps:
http://vyaskn.tripod.com/repl_ans4.htm#linkpubl

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page
   

- Advertisement -