Friday, February 24, 2012

Failure with transactional replication

I have set up a transactional replication with immediate updating push
subscriptions:
Distributor: W2003, SQL 2000 Standard SP3
Subscriber: WXPSP2, MSDE2000A (SP3)
When I try to update rows at the subscriber with Enterprise Manager, I have
the following error:
Database error: [Microsoft][ODBC SQL Server Driver][SQLServer][OLE/DB
provider returned message: Login failed for user 'sa']
Both servers have strong 'sa' password.
I tried the methods in KB320773, but i receive the error message.
Does anybody know how can I do that?
Thank you
Lajos Szabo
have a look at this kb article
http://support.microsoft.com/default...b;en-us;320773
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lajos Szabo" <Lajos Szabo@.discussions.microsoft.com> wrote in message
news:45B1C0ED-F6CC-4377-A3D2-21F1602FC429@.microsoft.com...
> I have set up a transactional replication with immediate updating push
> subscriptions:
> Distributor: W2003, SQL 2000 Standard SP3
> Subscriber: WXPSP2, MSDE2000A (SP3)
> When I try to update rows at the subscriber with Enterprise Manager, I
have
> the following error:
> Database error: [Microsoft][ODBC SQL Server Driver][SQLServer][OLE/DB
> provider returned message: Login failed for user 'sa']
> Both servers have strong 'sa' password.
> I tried the methods in KB320773, but i receive the error message.
> Does anybody know how can I do that?
> Thank you
> Lajos Szabo

No comments:

Post a Comment