Post reply

Alter publication property of allow anonymous subscriptions

  • November 27, 2005 at 8:34 pm

    #89972

    Hi i was wondering how i can change the property of allowing anonymous subscriptions.

    ive been up and down bol for a sp that would help, but so far no luck?

    would i need to drop and create the publication to set this option.?

    Thanks ladies and gents for any help you can provide.

    its a merge publicaton


    ------------------------------
    Life is far too important to be taken seriously

  • November 30, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • November 30, 2005 at 12:11 pm

    #606839

    In Enterprise Manager, Expand the replication folder and publications folder on the publisher.  Right click on the publication and select properties.  On the Subscription Options tab uncheck the "allow Anonymous Subscriptions" option.

     

    Mark

  • November 30, 2005 at 2:41 pm

    #606886

    Exec sp_changepublication

    @publication = 'yourpublication'

    ,@property = 'allow_anonymous'

    ,@value = 1

    ,@force_invalidate_snapshot = 1

    ,@force_reinit_subscription = 1

    The key is to look at the @Property parameter value, in this case you want to change the allow_anonymous value from "true" to "false" or vice versa. This value has a bit mask of 1 0r 0 simply execute this stored procedure setting the @paublicaiton parameter value to 1 or 0 and you should be fine.

  • November 30, 2005 at 2:57 pm

    #606898

    You might find that you will need to run the snapshot agent as well so that the new permissions are picked up.

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply