all groups > sql server replication > july 2003 >
You're in the

sql server replication

group:

Re: distributor_admin


Re: distributor_admin Jose
7/31/2003 7:55:31 AM
sql server replication: Hello,
Does the distributor_admin login need to have System
Administrator privileges? I am trying to audit and clean-
up our SQL Server logins and was wondering about this
account.

Thanks!
Re: distributor_admin Greg Yvkoff [MSFT]
8/1/2003 10:32:28 AM
distributor_admin is used only by replication (internally), and requires a
password at replication setup/configuration so publisher can connect to
distributor/distribution database. IT's not recommended to change the
permissions for this login.



--
This posting is provided "AS IS" with no warranties, and confers no rights.

thanks.
greg


[quoted text, click to view]

Re: distributor_admin Jose
8/1/2003 11:49:40 AM
Thanks for the info Greg.

However, does this mean that, if I am Using Windows
Authentication, I would not see this account?

Thanks
[quoted text, click to view]
Re: distributor_admin Deepak kumar [MSFT]
8/1/2003 2:10:51 PM
Here is the section from BOL which may shed some light:

thanks - Deepak
Connecting to the Distributor
The Distributor can be the same server as the Publisher (local Distributor),
or it can be a separate server from the Publisher (remote Distributor). When
using remote Distributors, you can configure the security necessary when the
Publisher and Distributor connect.

The connection between a Publisher and a remote Distributor is a hybrid of a
linked server and remote server. The connection uses the login
distributor_admin. At the remote Distributor, the Publisher can be
configured to be either trusted (no password is required for the
distributor_admin login) or non-trusted (a password is required).

It is recommended that you use a non-trusted connection for the Publisher
connection to the Distributor, requiring a distributor_admin password. This
increases security at the Distributor by restricting access. Members of the
sysadmin or db_owner roles who want to use a Distributor must know the
administrative link password. An incorrect distributor_admin password at the
Publisher causes the configuration of replication at the Publisher to fail.



Warning Do not change the password for the distributor_admin manually.
Always use either sp_changedistributor_password or the Distributor tab of
the Publisher and Distributor Properties in SQL Server Enterprise Manager
because password changes are then applied to local publications
automatically. Changing the distributor_admin password manually causes
publications using a local Distributor to fail.



This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]


begin 666 warning.gif
M1TE&.#EA# `+`(#_`/\``,# P"'Y! $```$`+ `````,``L`0 (1C(^I&^#<
-'G,`4HC-G3+S>A0`.P``
`
end
AddThis Social Bookmark Button