sql server replication: Can't get Transactional Replication to work. -- sql server replication

Can't get Transactional Replication to work.

Ty
8/26/2003 12:22:35 PM

sql server replication:

Hello,

I have an issue which is driving me nuts. The issue is
with transactional replication with immediate updates.

I have two sql servers (Server A and Server B).

Server A is the publisher and distributor and I have set
up a trans. replication with immediate updates to Server B.

The initial transaction completes successfully and on
Server B, I have the desired table and data.

On Server A, I update a field (say Sally to Sue) on the
FName field. Server B receives the update fine.

On Server B, I update the same field (say Sue to Jane) on
the FName field, but I get an error message: Login failed
for user sa.

Where is this coming from? On Enterprise Manager I
registered the two servers and can see the two tables. I
have put an entry in PAL and retyped the password many
times just in case I may have goofed. I did the same for
the subscription.

The only thing I see as a problem is that one of my server
is registered as <computer name>\NETSQL because I
installed Visual Studios .NET and my SQL server now has my
computer name, slash, NETSQL. I don't know how to create a
login using <computer name>\NETSQL because computer name
is not a domain. I created just my computer login with
full permissions, but I still get a login error when using
replication. Anyway, I am at a lost and if anyone can help
thank you very much.

Can't get Transactional Replication to work.

David Russell
8/26/2003 12:52:38 PM

If you want to do bi-direction replication, you should use
merge, not transaction.

David
[quoted text, click to view]

RE: Can't get Transactional Replication to work.

gopal NO[at]SPAM online.microsoft.net
8/27/2003 2:46:25 AM

When you use immediate updating subscriber and make changes on the
subscriber we initiate a distributed transaction
against the publisher to make the modification on that side.
Try running sp_link_publication on the subscriber with the appropriate
parameters (from books online and see if that fixes the issue)

Thanks
Gopal

RE: Can't get Transactional Replication to work.

Ty
8/27/2003 11:17:41 AM

Gopal,

Thank you very much. The sp_link_publication was the
problem.

Thanks also to Narayana Vyas Kondreddi and his web site
(http://vyaskn.tripod.com/repl_ques.htm) for posting an
FAQ that matches exactly what I was experiencing with a
good, descriptive answer!

In my opinion, the "replication overview" on SQL Server
BOL does not address this very well -- although it is in
there.

Thanks,
Ty

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.