Does the administrator windows login name and password of all servers
participate in replication must be the same?, or may I use the SQL
authentication?IIRC, Replication using windows authentication requires a trusted connection
using the same account on both end. BOL also has this:
Connections to a server (Publisher, Distributor, or Subscribers) can use
Windows Authentication or SQL Server security. Windows Authentication is
generally preferred for greater security and ease of use; however,
connections to Windows 98 servers must use SQL Server security because
Windows Authentication is a feature only on Windows NT 4.0 and Windows 2000.
It is recommended that the Subscriber connection have dbo permissions in the
subscription database to make sure the proper permissions are granted, and
for overall simplification; however, dbo permissions are not
If you are connecting to an untrusted domain you may wish to use SQL
authentication although this will weaken security.
Neil MacMurchy
"Tal" <talg@.nice.com> wrote in message
news:OjhYTt2$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> Does the administrator windows login name and password of all servers
> participate in replication must be the same?, or may I use the SQL
> authentication?
>sql
Wednesday, March 21, 2012
Replication and Windows login
Labels:
administrator,
database,
login,
microsoft,
mysql,
oracle,
participate,
password,
replication,
server,
servers,
sql,
windows
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment