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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Login Failed for user sa

Author  Topic  shahid Starting Member 2 Posts Posted - 2005-04-19 : 00:46:29 Hi I am configuring transactional replication on two sql servers 2000 which are at different domains. i made one server as publisher as well as distributor and other as subscriber. when i made changes at publisher, then these changes are replicated successfully to other server. but when i made updatable subscriber and try to make some changes at subscriber then i was not able to insert data from publisher and even from subscriber and error message appears as "Login failed for user 'sa': Reason not associated with trusted sql server connection" msg 18452 i am waiting for your positive response