This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 28.000000000000004%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Publication, distribution and Subscription are created successfully with no errors.
I encountered errors during runtime of the push subscription job, the system will show that it cannot connect to the subscriber. If I create a pull subscription job during runtime, the system said that it cannot connect to the distributor. May I know what could be the issue? Should I use other kind of authentication method to setup the replication instead of using Windows authentication?
Background information
I created only 1 window local account named as snapshot account on each server. (publisher and distributor on same server) and subscriber(running on virtual machine on another server remotely).
I did not create 3 accounts instead such as log account,distribution account, snapshot account
These two servers are connected to different domains remotely.
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
I don't work much with replication, so I may not be able to help. But I would advice you include the exact error messages you are getting. That may increase your chances for getting help.
This is the UNC for the shared folder where replication files are store . Make sure that the account running replication jobs has access to this folder.
You can test it by accessing the share from the distribution server host
Hi Jose,
How do I test that the unc shared folder is setup and working as intended from distribution server host?
Can you send me a step by step guide?
Can we configure Merge replication to allow one direction way of updating the data from publisher to subscribers not allowing updating data from subscribers to publisher?
Hi,
I encountered another error "The process could not read file'\hostname\repldata\unc\tt1_2pre' due to OS error 53" appears in sessions of the distribution agent area under distributor to subscriber history tab of the pull subscription.
Any advice?
NET HELPMSG 53 tells me: "The network path was not found."
That suggest that there is an issue with \hostname in the path.
Hi all,
I managed to resolve this error "The process could not connect to Distributor hostname" by creating alias at the sql configuration manager.
Now I have another error, "The job failed. The Job was invoked by User XXX. The last step to run was step 1 (Run agent.)." when I clicked on the view synchronization status of the pull subscription.
Question 1) When I selected a snapshot replication, can I create a pull subscription?
Question 2) May I check SQL Server Agent should be started by which account?
Question 3) What could be the possible causes of this error?
Thanks.
You should find the Agent job and view the history of the job, and look at the output from the job step to see what the actual error message was.