Hi All,
I'm looking at the replication security on one of my servers (admittedly I
haven't used replication that much before), we are running transactional
replication and I wondered what the distributer_admin login does... ...is it
safe to remove the distributer_admin login? - or at least change it to a
windows authenticated login?
Thanks in advance
Ben
Don't touch this account, if you remove it replication will not work. It is
an account which is used to proxy RPC calls between the
Publisher/Distributor/Subscriber.
IIRC, you can remove it after you have created your publications,
subscribers, distributor, but after you remove it you will no longer be able
to configure any more publishers or subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"BenUK" <BenUK@.discussions.microsoft.com> wrote in message
news:C16AE4CB-6D92-4DCF-98B5-AFD0DBCCC6ED@.microsoft.com...
> Hi All,
> I'm looking at the replication security on one of my servers (admittedly I
> haven't used replication that much before), we are running transactional
> replication and I wondered what the distributer_admin login does... ...is
> it
> safe to remove the distributer_admin login? - or at least change it to a
> windows authenticated login?
> Thanks in advance
> Ben
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment