Publisher Problem - 05-18-2006 , 08:13 AM
I have encountered a problem when I was creating the transactional
replication. My design was putting the distributor and subscription on
the same machine. I was able to create the distributor however when I
tried to create Publisher from publication machine it asks me to define
the publication machine on the distiributor as a publisher. However
properties of the replication dose not give me that option. I can only
choose the distirbutor as a publisher not the another machine.
can some one help me on this issue?
Re: Publisher Problem - 05-18-2006 , 08:33 AM
Did you run sp_adddistributor on the publisher's box?
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
RE: Publisher Problem - 05-18-2006 , 03:33 PM
Hi laststubborn, on the same machine that was not possible on transactional
MCP, MCDST, MCSA, MCSAM, MCSE, MCSEM, MCDBA
Re: Publisher Problem - 05-18-2006 , 08:23 PM
it is possible.
Looking for a SQL Server replication book?
Looking for a FAQ on Indexing Services/SQL FTS
"Pedro Marques" <pmarques.net (AT) netcabo (DOT) pt> wrote
Re: Publisher Problem - 05-24-2006 , 01:22 AM
I found out that it is possible. It might be a version problem from my
SQL Test server. I guess it was a personal eddition now I am
reinstalling a server OS and I will install enterprise eddition on top
of it lets see whats gonna happen