sql server replication: login failed for user 'sa' -- sql server replication

Leon Shargorodsky
7/12/2007 10:32:05 AM

sql server replication:

I'm trying to set up a very simple model of Transactional Replication using
SQL 2000 Enterprise:
Single Publisher (Distributor resides on the same box), two Subscribers with
updatable subscriptions.
I have no problems distributing changes from Publisher to Subscribers.
However, when I try to update a table on Subscriber, I get this:

Server: Msg 18456, Level 14, State 1, Line 4
Login failed for user 'sa'.

Help, please...

Re: login failed for user 'sa'

Hilary Cotter
7/12/2007 1:50:05 PM

http://support.microsoft.com/kb/320773

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leon Shargorodsky" <LeonShargorodsky@discussions.microsoft.com> wrote in
message news:1E995FD0-6A18-4D4E-8EA5-95BDE180C83F@microsoft.com...
[quoted text, click to view]