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

sql server replication

group:

authentication mode for Replication



authentication mode for Replication James
2/13/2004 8:51:08 PM
sql server replication: Hi,

I am planning to setup replications on my SQL Server 2000
BOX ( publisher + Distributor) and subscriber on another
BOX . I use Mixed mode authentication for both the boxes
and it is MUST for my applications to communicate with SQL
server. Do I need to worry about authentication modes (
windows, mixed) while setting up replications. Also which
authentication mode is the best practice while replicating
over Internet.

Inputs are highly appreciated.

Regds

Re: authentication mode for Replication Hilary Cotter
2/14/2004 7:53:49 AM
you must use mixed when replicating over the internet.

When you use mixed you must specify a sql account.

[quoted text, click to view]

Re: authentication mode for Replication James
2/14/2004 8:02:30 AM
Hi Hillary,

Thanks for the reply. I have one more doubt. from "SQL
Server 2000 Higher Avaliablity" Planning document
<excerpt>
Finally Transactional Replication requires prepration of
schema for replication, Identity Columns and triggers must
set to NOT FOR REPLICATION ; literals must be defined with
apostrophes rather than Quotation marks; primary key must
be defined for every table and database Objects must not
include unresolved references
</excerpt>

The above stuff bounces out of my head as I am new for
replications.

Thanks and Regards

James
[quoted text, click to view]
AddThis Social Bookmark Button