The process could not read file D:\XXXX\X.pre (source: MSSQL_REPL, Error Number: mssql_repl20024) due to operating system error 3

Source: Internet
Author: User
Tags mssql mssqlserver

Today, when the server does publish + subscribe, there is a problem, as follows:

The process could not read the file "D:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\repldata\unc\ because of operating system error 3 User-n18o5dgqu6_cloudtradb_gypt_gypt_f\20151127091512\fn_diagramobjects_129.pre ". (Source: MSSQL_REPL, Error number: mssql_repl20024)
Get help: http://help/MSSQL_REPL20024

The main reason for this problem is that subscribers access the subscription directory snapshot "D:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\repldata\unc\ User-n18o5dgqu6_cloudtradb_gypt_gypt_f\20151127091512\fn_diagramobjects_129.pre "failure caused.

How to resolve:

1. Set the directory hosting the snapshot to share, and set the Read permission;

1) Publishing Server settings:
In the publication properties, click the snapshot on the left and the location of the snapshot file in the right page defaults to D:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\repldata
Set the Repldata folder to shared, and in the security key, set user permissions

2) Subscriber Settings:
Then at the Subscriber, right-click the service name of the subscription, select Properties, set the property parameters as follows
A. Snapshot location modified to alternate folder
B. Snapshot folder modified to \ \ publisher Ip\repldata

2. The request subscription is changed to a push subscription;

The process could not read file D:\XXXX\X.pre (source: MSSQL_REPL, Error Number: mssql_repl20024) due to operating system error 3

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.