I configure Transactional Replication using SQL Authentication. The subscription account was added to the PAL and it belongs to the Sysadmin group and database_owner role. When I clicked on the VIEW SUBSCRIPTION STATUS and the result shows that the synchronization is working. I also compared the tables in both the publisher and subscriber databases and the number of rows are the same. However when I clicked on the PROPERTIES of the VIEW SUBSCRIPTION STATUS Button I saw the message that the synchronization was "unable to connect to the Distributor."
Software/Hardware used: SQL SERVER 2008R2 REPLICATION
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!