Guest account in the Distribution database -- sql server replication

Abraxas
10/5/2006 2:50:22 PM

Hi,

I noticed that the "guest" account gets created by default and assigned to
the Distribution database. We are using transactional replication with
updatable subscribers and anonymous subscriptions and need to be able to
remove the guest account from the distribution db.

- Is it possible to remove the guest account from the dist. db and still use
anonymous subscriptions?

- If not, is there any security vulnerability or risk associated with
leaving the guest account assigned or using anonymous subscriptions?

- Any gotchas in configuring non-anonymous subscriptions with trans-repl and
updatable subscribers?

Thanks !

Hilary Cotter
10/5/2006 10:14:43 PM

The guest account is in every database. Anonymous subscribers don't use it.

By default I believe the guest account is disabled. I don't know what the
consequences of removing it are.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]

sql server replication : Guest account in the Distribution database