February 6, 2002 at 6:30 am
I am having problems setting up Immediate-Updating Subscribers. The login failure happens when I do data updates to the subscriber database and it attempts to reach over to the publisher to make the same update.
Publisher is a SQL Server 7.0 with SP 3
Distributer and Subscriber are the same server running SQL Server 7.0 SP 2
After setting up the replication I ran the stored procedure sp_link_publication on the distributer/subsciber server, but it did not resolve the login failure.
I have setup this replication scenario before and was able to work through it, now I am having problems.
Any suggestions?
Thanks.
- Brendan
February 6, 2002 at 6:35 am
Is the DTC running? You're using SQL login and not NT authentication? I'd double check the data in MSsubscription_properties to make sure everything look good.
Andy
February 6, 2002 at 6:59 am
Thanks for the suggestions
Yes, MSDTC service is running.
I've tried toggling both SQL Login and NT authentication.
I think my next step is to tear it down and start over. Perhaps I fat fingered something along the way.
I'm open to any more ideas (please!).
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply