<div>
<div class="content wysiwyg-content">
Hi,<br />
Anyone know how could I connect to 2 or more distributor for single publisher? I have an instance of sql server (publisher) with few db and I want it to connect to difference distributor. Currently I only saw one distributor exist and there is no option to create configure another one in EM.<br />
<br />
sp_get_distributor only show one as &nbsp;now.<br />
<br />
installed distribution server &nbsp; &nbsp; &nbsp; &nbsp;distribution db installed is distribution publisher has remote distribution publisher <br />
--------- --------------------------<wbr />----------<wbr />----------<wbr />-- ------------------------- ------------------------- -----------------------<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; TSD001\SQL1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0<br />
<br />
<br />

</div>
</div>


Hi,
Anyone know how could I connect to 2 or more distributor for single publisher? I have an instance of sql server (publisher) with few db and I want it to connect to difference distributor. Currently I only saw one distributor exist and there is no option to create configure another one in EM.

sp_get_distributor only show one as  now.

installed distribution server        distribution db installed is distribution publisher has remote distribution publisher 
--------- ------------------------------------------------ ------------------------- ------------------------- -----------------------
1         TSD001\SQL1               0                         0                         0




Can publisher server connected to multiple distributor

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.