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.
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,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|