Security in Transactional Rep.

  • I have a transactional Repl with immediate updates set up between two SQL2k servers. The publisher and distributor is in the domain and subscriber in in Win2k workgroup (web server). The replication works fine from the Publisher but when I try to insert a record on the subscribers side I get this error:

    [Microsoft][ODBC SQL Server driver][SQL Server]Login Failed for user 'sa'.

    any ideas what can be causing this? an how to get it working on both sides?

    Thanks,

    Jakub

  • I believe the subscriber has to also run under a domain account for the two way to occurr. I usually set all my SQL Servers to use the same domain account as their servioce account, this way I have fewer issues. I have been meaning to try this as I have a recent need for it. May also be, by the fact it states SA that the password for SA on the suscriber is different that the publisher, set both the same and see what happens.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply