sql server 2008 replication: Subscription not showing up in Local Subscriptions

  • Pub & Sub: 2008R2 Ent 64bit

    Distribution:20012 Ent 64bit.

    When I try to add new Subscription to the Local Publication.

    It say successfully created, I can see the Subscription under that publication.

    But I cant see it on Local Subscription on Subscription server.

    can help can be greatly appreciated.

    thanks

  • When I check Subscription properties on the publisher server.

    in Subscription Option status: pending

  • Hi,

    Are you able to see in Subscriber server?

    ---

    Satish

  • Can you please use T-SQL commands to create subscription.

    Chandan

  • chandan_jha18 (8/27/2012)


    Can you please use T-SQL commands to create subscription.

    Chandan

    Although I prefer that myself, how does this help the issue? To the OP, is your distributor local to the publisher or separate (obviously a different instance since it is a different version)? Also, did you get any warnings when you created the subscription? Have you tried deleting it and recreating it? What are your linked server settings?

    Jared
    CE - Microsoft

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

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