Hardware environment:
sqlserver2008 database installed on one server
LAN and a machine with a sqlserver2000 database installed.
No problem with both server communication shares
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" due to an operating system error 5: Step failed .
The subscription, advertisement Setup steps for the database:
Data synchronization from sql2008 to sql2000, sql2008 database replication---> Local announcement-New announcement
Connect remotely to sqlserver2000 with sqlserver2008 on replication--local subscription--New subscription
The SQL Server 2008 Agent service started generating the corresponding snapshot.
sqlserver2000-side subscription startup agent has been unable to access shared files. the prompt process failed to read the file "\ \ Snapshot Path" due to an operating system error 5: Step Failed .
The workaround:
☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆ Online Search for a very long time. has not been successful my own solution to the method such as the following: ☆☆ ☆ ☆ ¡î ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆
In the server where sqlserver2008 is installed:
1, join a User: (Local Users and groups) to join a user such as: userxyz Let it belong to administrators.
2. Locate the published snapshot directory. Add userxyz users to the share.
In the server where sqlserver2008 is installed:
1, join a User: (Local Users and groups) to join a user such as: userxyz Let it belong to administrators. ( note that this user's username and password must be the same as the Usernamepassword added to the sqlserver2008 installed server)!!
!!
2, find SQLServerAgent Agent service in the service right-click Properties---> Login---> This user-browse to select just usexyz---> Input usexzy password---> click OK --Another time to start the agent service.
Database---> Local announcement----> Snapshot generation in SQL Server 2008 servers
SQL Server 2000 Servers database---> Local subscriptions---> another subscription.
The data is synchronized successfully.
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