SQL Server 2005 replication configuration

Question

Hi Folks,

Does anyone have a link to a decent tutorial on configuring SQL Server 2005 replication. The article needs to explain how to configure the correct security for the replication snapshot agent, there a lots of articles out there but they all seem to miss out on that part of the process.

Or....if someone has set this up already between two standalone (i.e. not in a domain) SQL 2005 Standard Edition servers using transactional replication maybe you can provide me with some advice and guidance.

I plan to use a simple publisher subscriber model and use the publishing server as the distribution database server. The subscriber will be read only.

Much appreciated.
Kev

Answer 1

check out this one. Might help here.

Answer 2

I actually picked up this chunky doorstop from APress. Covers pretty much what I'm after:

http://www.apress.com/book/view/9781590596500