SQLServer replication problem: always encounter errors. Is it really cool to configure these things?

Source: Internet
Author: User
Assume that the Publishing Server ip address is 10.1.22.35. In the publishing properties section (right-click the publishing name), click the snapshot on the left, and the default location of the snapshot file on the right is D: programFilesMicrosoftSQLServerMSSQL10.MSSQLSERVERMSSQLrepldata set the repldata folder to share and add EVERYO to the security item

Assume that the Publishing Server ip address is 10.1.22.35. In the publishing properties section (right-click the publishing name), click the snapshot on the left, and the default location of the snapshot file on the right is D: \ Program Files \ Microsoft SQL Server \ MSSQL10.MSSQLSERVER \ MSSQL \ repldata set the repldata folder to share and add EVERYO to the security item

Assume that the Publishing Server ip address is 10.1.22.35.
In the release attribute (right-click the release name), click the snapshot on the left. The default location of the snapshot file on the right page is
D: \ Program Files \ Microsoft SQL Server \ MSSQL10.MSSQLSERVER \ MSSQL \ repldata

Set the repldata folder to share, add the EVERYONE user to the security item, and check all permissions.


In the subscription server, right-click the subscribed service name and select properties. In the displayed window
1) Change the snapshot location to a backup folder.
2) Change the snapshot folder to \ 10.1.22.35 \ repldata.

Note: The subscription server must be able to access \ 10.1.22.35 \ repldata

Go back to the Publishing Server, in local publishing, right-click the subscription name, select start replication monitor, and you will be able to see that the subscription has been published successfully (no red error occurs)

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.