Anonymous Subscriptions using SQLDMO

Hi guys - I have been able to successfully create pull merge
subscriptions in SQLDMO. Now I am trying to do anonymous subscriptions and I
am having a little difficulty.
I made sure to allow anonymous subscriptions at the publication. I
created an object of type MergePullSubscription2 and called it "sub" and set
the properties as follows:
sub.SubscriptionType = .SQLDMOSubscription_Anonymous;
sub.SubscriberType = .SQLDMOMergeSubscriber_Anonymous;
(and set all the other properties appropriately) and then added it to
the MergePullSubscriptions collection.
All of that works fine. But then I try to enable it at the publisher by
using the method EnableMergeSubscription (I make sure to use the constant
SQLDMOMergeSubscriber_Anonymous for the SubscriberType argument) and that
gives me the following error:
"[Microsoft][ODBC SQL Server Driver][SQL Server]The remote server is not
defined as a subscription server."
(this is strange because I can create other subscriptions that are not
anonymous)
Is this step (EnableMergeSubscription ) necessary? It seems to be
because if I try to sync, it fails.
It seems like anonymous subs should be pretty straightforward, but I
must be missing something fundamental.
Any help will be much appreciated.
Maer
Hello,
I suggest that you refer to the information on the following web site:
MergePullSubscription Object
http://msdn.microsoft.com/library/de...us/sqldmo/dmor
ef_ob_m_0egk.asp
To create a merge anonymous subscription at the Subscriber:
1.Create a new MergePullSubscription object.
2.Set the Publisher property to the name of an existing Publisher.
3.Set the PublicationDB property to the name of the database (at the
Publisher) where the publication is located.
4.Set the Publication property to the name of the publication to which to
subscribe.
5.Set the SubscriberType property to SQLDMOMergeSubscriber_Anonymous.
6.Set the SecurityMode property of the DistributorSecurity object property
as appropriate.
7.If the SecurityMode property of the DistributorSecurity object property
is set to SQLDMOReplSecurity_Normal, set the StandardLogin and
StandardPassword properties of the DistributorSecurity object property.
8.Set the SecurityMode property of the PublisherSecurity object property
as appropriate.
9.If the SecurityMode property of the PublisherSecurity object property is
set to SQLDMOReplSecurity_Normal, set the StandardLogin and
StandardPassword properties of the PublisherSecurity object property.
10.Note that the Name property defaults to
publisher:publication_database:publication.
11.Add the MergePullSubscription object to the MergePullSubscriptions
collection of a connected ReplicationDatabase object at the Subscriber.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Angry about Reporting Services

I have seen the odd thread on here that just mentions in passing that data-driven subscriptions are only available on the SQL 2005 Enterprise edition. Does no-one else but me think that this is absolutely disgraceful? We bought SQL Server Standard for our 2 processor server and it cost just under ￡8,000. The only reason we would have to buy Enterprise is for the data-driven subscriptions in RS and that would cost us ￡33,000. When the beta of RS came out, it had data-driven subscriptions at all levels. When RS 2000 came out, we could easily get a legitimate copy of RS 2000 Enterprise from Microsoft and have the same functionality. Now we have to pay ￡25,000 for the privilege or hand-code the whole thing. I repeat; this is an absolutely disgraceful piece of profiteering from Microsoft. Do they really think that data-driven subscriptions are only of value to people using the Enterprise edition?

This forum is intended for assistance and bug reporting with RS. Call customer support if you're that upset about the product. What do you expect them to do? Give it to you for free now because you're angry?

I think it is disgraceful that you would use an open forum to vent about a product that you purchased which is documented as to what it includes and what it does not include.

|||

I think it's disgraceful that a product which was in all versions of the beta and freely available in SQL 2000, now costs me ￡25,000 in SQL 2005. Don't you?

As I believe this forum is read by Microsoft developers, maybe I thought they could give me a rational response. If you know of a place where I can get a better response, or where I ought to post this, please let me know. It is not my intention to upset anyone on the forum, just to let Microsoft know how I feel about their product.

|||

Leaving strong words aside, I think your complaint is not unreasonble and it is good to provide this kind of feedback. Crossing the enterprise hefty price tag is not an easy sell especially for vendors. I tend to agree with you we are suffering from an "enterprise" identity crisis and thus the meaning of enerprise should be better scoped out. IMO, enterprise editions should differ only in the areas of scalability and to some extend extensibility in order to meet high loads and more involved integration requirements of large companies. Following this line of thought, I'd say that web farm deployment and partitioning are definately enterprise-level features while features like data-driven subscriptions and semi-additive measures (SSAS) are probably not.

From BOL: "Enterprise Edition scales to the performance levels required to support the largest enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. Enterprise Edition’s comprehensive business intelligence and analytics capabilities and its high availability features such as failover clustering allow it to handle the most mission critical enterprise workloads. Enterprise Edition is the most comprehensive edition of SQL Server and is ideal for the largest organizations and the most complex requirements."