Failure with transactional replication with immediate updating subscriptions

I have set up a transactional replication with immediate updating
subscriptions,
Distributor and Subscriber on diff servers.
When I try to update rows in the subscriber I have the following error:
[Microsoft][ODBC SQL Server Driver][SQLServer] Login failed for user 'sa'
(Both servers have the same 'sa' password)
Does anybody know how can I do that ?
Thank you
Hernn Rado
review this kb article:
http://support.microsoft.com/default...b;en-us;320773
"Hernn Rado" <hernan_radovitzki@.hotmail.com> wrote in message
news:eAt7HgE6EHA.2592@.TK2MSFTNGP09.phx.gbl...
> I have set up a transactional replication with immediate updating
> subscriptions,
> Distributor and Subscriber on diff servers.
>
> When I try to update rows in the subscriber I have the following error:
> [Microsoft][ODBC SQL Server Driver][SQLServer] Login failed for user 'sa'
> (Both servers have the same 'sa' password)
> Does anybody know how can I do that ?
> Thank you
> Hernn Rado
>
|||Thanks Hilary !
I changed the SA password to a blank one and its works ! Later, I changed
again both password (to the original) and ran the sp_link_publication on the
subscriber (specifying the SA psw) but its doesnt work !!
What can I do?
"Hilary Cotter" <hilary.cotter@.gmail.com> escribi en el mensaje
news:O5fVNsE6EHA.248@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> review this kb article:
> http://support.microsoft.com/default...b;en-us;320773
> "Hernn Rado" <hernan_radovitzki@.hotmail.com> wrote in message
> news:eAt7HgE6EHA.2592@.TK2MSFTNGP09.phx.gbl...
'sa'
>

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