Login failed for user 'sa'.

  • 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

  • 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

  • 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