|
Home > Archive > MS SQL Server > February 2006 > Replication Security
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Replication Security
|
|
|
| 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
| |
| Hilary Cotter 2006-02-06, 11:23 am |
| 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@microso
ft.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
|
|
|
|
|