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)