Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server 2008 replication: Subscription not showing up in Local Subscriptions Expand / Collapse
Author
Message
Posted Friday, August 24, 2012 10:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:00 AM
Points: 153, Visits: 573
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
Post #1349794
Posted Friday, August 24, 2012 10:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:00 AM
Points: 153, Visits: 573
When I check Subscription properties on the publisher server.

in Subscription Option status: pending
Post #1349796
Posted Monday, August 27, 2012 12:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi,
Are you able to see in Subscriber server?

---
Satish
Post #1350216
Posted Monday, August 27, 2012 1:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:28 AM
Points: 449, Visits: 1,831
Can you please use T-SQL commands to create subscription.

Chandan
Post #1350230
Posted Monday, August 27, 2012 1:31 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:37 AM
Points: 2,673, Visits: 3,325
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?


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1350550
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse