SQL 2000 Replication fails w/o SA account.

[Dave S.]

Hi All,
Here's my scenario, I have 2 win2k domain controllers, in a parent child
relationship. I installed sql2000 w/sp2 on each. I
configured for the sqlserveragent and mssqlserver services
on each to use the same domain user account with domain
admin and local admin rights. The SQL servers are running
in TRUSTED WINDOWS MODE ONLY. I've implemented a
transactional replication with immed. updateing option.
It works fine one way, from the publisher.

When I update at the subscriber table I get a
"SA login failed, trusted connection" error.

There is no where I can find that I've told it to use SA.
All my options say use trusted connection.
On a side note I tried to set up a proxy job account and
it wouldn't let me even add one in, kept failing my valid
users.
Any help is appreciated.
TIA,
Dave
.

[bamcorp]

Check your Server properties.

select your database server in Enterprise Manager.

Select SQL Server Properties from the Tools menu.

Select the Security tab.

Verify that authentication is set for SQL Server and Windows NT.

If it is not, set it and sop and restart the service.