Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have 3 separate SQL Server 2012 databases running on 3 VM's. I have successfully configured one pull subscription to the distributor but when I add a 2nd subscription on another SQL Server the subscription never initializes. The new subscription is configured exactly the same as the working subscription.

Both subscriptions are set to impersonate the service account. Is there a way to see exactly what the failure is?

share|improve this question
1  
Open up the Replication Monitor and take a look at the agents. You should be able to see the errors that correspond to your issue. –  Thomas Stringer Dec 4 '12 at 15:14
    
Replication Monitor does not show any detail on the subscription with uninitialized status. When I attempt to see the errors the message is "Replication Monitor could not open the Detail Window" –  Syn Dec 4 '12 at 15:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.