Push Transactional Replication
Replication was running fine, we switched one of the servers in the local lan to named pipes.
We can still connect to the database with Query Analyzer (QA) and Enterprise Manager (EM) but replication failed.
We realized that the linked server on the distributer for that subscriber could not connect.
We switched back to TCP and all is well again.
We can issue a Net Use \\server\ipc$ with success so it seems the pipe is ok, and we can still connect with QA and EM.
Why would the protocol make a difference. Why can't we connect a linked server with Named Pipes when it connects fine with TCP, and why even though the linked server can not connect can swe till connect with QA or EM.
More info please:
What agent is failing, distribution agent? Is logreader/snapshot agent functioning properly?
Which machine was configured to use named pipes, distributor or subscriber?
Did you change this at the client level or server level?
When you use QA/EM, are you connecting locally or remotely?
What error are you getting?
No comments:
Post a Comment