Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Selecting remote Distributor

Author  Topic 

netjam
Starting Member

37 Posts

Posted - 2008-05-18 : 21:29:18
I have distributor up and running. On distributor I enabled two publishers. I had no issues with adding remote distributor one of the publishers. However on the second publisher radio option for ‘Use the following server’ when selecting distributor is disabled.
How can I enable this option?

The distributor server is registered on publisher.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-18 : 22:03:42
When create publisher or later?
Go to Top of Page

netjam
Starting Member

37 Posts

Posted - 2008-05-18 : 22:06:36
I unable to create publisher because I cannot select remote distributor on Troubled server.
Go to Top of Page

netjam
Starting Member

37 Posts

Posted - 2008-05-18 : 22:08:53
Publisher was enabled on Distributor before I attemppted to create a publisher
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-18 : 22:11:58
You need new publisher? Is it for same db as existing publisher?
Go to Top of Page

netjam
Starting Member

37 Posts

Posted - 2008-05-18 : 22:19:25
Yes I need a new publisher. But it's different db with the same schema.
One distributer and two publications = two subscibers respectively.
Go to Top of Page

netjam
Starting Member

37 Posts

Posted - 2008-05-18 : 22:20:49
Do I need another distributor?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-19 : 22:54:36
Don't have to, but should be ok if you like.
Go to Top of Page
   

- Advertisement -