A push subscription to transactional replication has been implemented under Sql2000 sql2005 sql2008, but a pull subscription always fails to implement the following error prompt

Hardware environment:

sqlserver2008 database installed on one server

LAN another machine installed the sqlserver2000 database

No problem with both server communication sharing

Problems that are encountered during synchronization:

forced to implement transactional replication under Sql2000 Subscribe, but the requestSubscribealways fail to implement the following error prompt:the process could not read the file "\ \ Snapshot Path" because of an operating system error 5: Step failed .

The subscription, publish setting steps for the database:

Data synchronization from sql2008 to sql2000, sql2008 database replication---> Local release-New release

Connect remotely to sqlserver2000 with sqlserver2008 on replication--local subscription--New subscription

The SQL Server 2008 Agent service started generating the corresponding snapshot.

The sqlserver2000-side subscription has been unable to access the shared file while starting the agent. the prompt process failed to read the file "\ \ Snapshot path" because of an operating system error 5: Step Failed .

Workaround:

☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆ Online Search for a long time, has not succeeded my own solution is as follows:☆☆ ¡î ☆ ¡î ☆ ☆ ☆ ☆ ☆ ¡î ☆ ☆ ☆ ☆ ☆

In the server where sqlserver2008 is installed:

1. Add a User: (Local Users and groups) add a user such as: userxyz Let it belong to administrators.

2. Locate the snapshot folder of the publication and add the USERXYZ user to the share.

In the server where sqlserver2008 is installed:

1. Add a User: (Local Users and groups) add a user such as: userxyz Let it belong to administrators. ( note that the user name and password for this user must be the same as the user name password that is added to the sqlserver2008 installed server)!!!!

2, find SQLServerAgent Agent service in the service right-click Properties---> Login---> This user-Browse to select the usexyz---> enter the usexzy password---> Click OK--> ; Restart the agent service.

Database---> Local publishing----> Regenerate snapshots in SQL Server 2008 servers

Database---> Local subscriptions---> re-subscriptions in SQL Server 2000 servers.

The data is synchronized successfully.