all groups > sql server replication > november 2004 >
You're in the

sql server replication

group:

Transactional Replication always uses sa account ?



Transactional Replication always uses sa account ? Wojtek Z
11/5/2004 2:22:40 PM
sql server replication: Hello
I've tried to change sa password. I've changed logging mode of all
subscribers ( for sa with new password, and even for some different account
with System Administrator privs. ). Then I've created a Bidirectional
Transactional Replication.:
A -> B
When I upload data to A it is ok - in few seconds all apeard at B.
When I try to upload data to B there's a message that "... 'sa' login have
failed ...).
With OneDirectional Replication it is ok. ( i can upload data to B ).
When i cleared the sa password, and changed subscribers loggin mode ( back
to 'sa' with blank password) it worked ok.

Best Regards
Wojciech Znaniecki

Re: Transactional Replication always uses sa account ? / Sorry, fogot the question :) Wojtek Z
11/5/2004 2:24:50 PM

U¿ytkownik "Wojtek Z" <wojtas_z@poczta.fm> napisa³ w wiadomo¶ci
news:cmfus1$j6s$1@atlantis.news.tpi.pl...
[quoted text, click to view]

Do I have to change anything else to use not-blank 'sa' password ?

Best Regards
Wojciech Znaniecki

AddThis Social Bookmark Button