sql server replication: Hi
We are using SQL 2K with Sp4. Both publisher and distributor are on the
same computer. We are using push repication.

Recently I changed the sa password without knowing that somewhere in our
push replication is using it. When I create a new subscription, it keeps on
telling me that sa login incorrect. Where is the sa hiding in this
subscription setting?

I need help quickly.

Please run sp_helpsubscriberinfo and see if the security_mode is 0 (sql
server authentication). If it is, then this is what needs changing.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com