May 19, 2005 at 9:50 am
Hi, I get this:
Exec sp_adddistributor @distributor = N'Server-C'
Server: Msg 14099, Level 16, State 1, Procedure sp_adddistributor, Line 72
The server 'repl_distributor' is already defined as a Distributor.
I ran the above on Server-B and got the error. It ran fine on Server-C. Here's my setup:
Server-A = Publisher of Database-X
Server-B = Pull subscriber to Database-X on Server-A
Server-B = Distributor
Now I want Server-B to become a publisher of Database-Y and I want Server-C to be the distributor. But the error seems to be telling me that I have to use Server-B as the distributor.
Am I doing something wrong or is this just how it is?
May 23, 2005 at 8:00 am
This was removed by the editor as SPAM
May 24, 2005 at 11:10 am
Assuming you meant:
Server-A = Publisher of Database-X
Server-B = Pull subscriber to Database-X on Server-A
Server-C = Distributor
The distributor database is already created and the server is already flagged as a distributor as database X uses server C as the distributor.
What you should look at, is the way to have your publication of database Y use the Server C as it's distributor.
Please open op BOL (SQL Books Online) and read the explanation of the sp_adddistpublisher procedure
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply