Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating new distributor in stand alone SQL Server Expand / Collapse
Author
Message
Posted Wednesday, August 7, 2013 3:25 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:39 PM
Points: 49, Visits: 363

In my environment, there is a replication configured by using the same server (Assume, Server A) as a distributor.

Now i need to create new replication as like before ,but this time I'm planning to create the distributor in a stand alone server (Assume Server D).

But, while creating the subscription , it won't detecting the Server D for distributor .
It consider the same server distributor which is already configured.

Note: Configured distributor in Server D and selected a publisher as Server A

My question is , Can't we create mutiple distributors in different servers?
Post #1482080
Posted Wednesday, August 7, 2013 5:07 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:39 PM
Points: 49, Visits: 363
I forgot to say one more thing, Those configurations ,I've done through GUI.

Does GUI misleading to identify the Server D ..?
Post #1482103
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse