Post reply

Can publisher, subscriber and distributor be on the same machine?

  • May 15, 2009 at 12:46 pm

    #204808

    For purely test and practice purposes, does replication work in slq server 2005 with the publisher and subscriber on the same machine, assuming i will have an instance for the publisher and an instance for the subscriber?

  • May 15, 2009 at 12:54 pm

    #995597

    This was available in SQL Server 2000 so it maybe in 2005 in 2000 the base requirement was running the Agent with a domain account, I have not used replication for a while so check the BOL.

    Kind regards,
    Gift Peddie

  • May 15, 2009 at 1:04 pm

    #995606

    winston Smith (5/15/2009)

    For purely test and practice purposes, does replication work in slq server 2005 with the publisher and subscriber on the same machine, assuming i will have an instance for the publisher and an instance for the subscriber?

    Yes, they can all be on the same machine.

    You are probably better of using virtual environments for this, it is cleaner, quicker and easy to set up but setting up two instances work as well.

    Take your pick.


    * Noel

  • May 18, 2009 at 8:08 am

    #996350

    Having both publisher and scubscriber on the same instance is not a good idea as per high avilability model. However this will work.

    We can configure for testing puerposes.


    - Pradyothana     http://www.msqlserver.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply