Friday, March 30, 2012
Named subscription is greyed out
several subscribers running MSDE 2000 and Merge Replication. Every
Subscriber connects to the publisher using Pull Subscription, but the choice
of selecting "No, This is a named subscription" is grayed out when
establishing the subscription. I therefore have to pick Anonymous
subscription... Why?
You'll need to register the subscribers first.
With the MSDE subscriber connected to your publisher, in Enterprise Mgr:
right click Replication and select the Config. Publishers, Subscriber and
Distributors option. On the Subscribers tab, select the box next to the
Subscribers to register them. Enter the connecting account using the ...
button. Then re-create the pull subscription.
Had the same problem myself recently.
Steve Halfacre
Synapsis, UK
<hallvardsc@.hotmail.com> wrote in message
news:%23dPPwIeLEHA.340@.TK2MSFTNGP11.phx.gbl...
> The system consists of one SQL 2000 Server (Distributor and Publisher) and
> several subscribers running MSDE 2000 and Merge Replication. Every
> Subscriber connects to the publisher using Pull Subscription, but the
choice
> of selecting "No, This is a named subscription" is grayed out when
> establishing the subscription. I therefore have to pick Anonymous
> subscription... Why?
>
>
sql
Saturday, February 25, 2012
My questions
I'm new for ssas and I'm studying NS samples,i found all the subscribers and subscriptions are created manully,my app have millions of subscribers and many different kinds of subscriptions,so how to create those objects through reading data from tables?
Much appreciate for your reply
In SSNS 2000, subscribers, devices, and subscriptions have to be created using the SSNS API using a programming language like C#, VB.NET, or VBScript. In SSNS 2005, we know have some views that can be used to create those rows in the database.
Here are a couple of links that may help.
http://sqlns.blogspot.com/2005/10/creating-subscribers-in-2005.html
http://sqlns.blogspot.com/2005/09/creating-subscribers-in-v20.html
http://sqlns.blogspot.com/2006/08/creating-test-subscriptions-in-sqlns.html
HTH...
Joe
|||Thanks in Advance