Hi,
I'm trying to set up transactional replication from one server to another (I've done this successfully a few times). I've set up the publications and pushed a subscription to the subscriber. But as soon as the snapshot agent starts, I get the following error
system cannot find the specified path
The path for the snapshot is valid, and I'm using a domain account which has acces to this folder to run the SQL Server Agent on both boxes.
Could anyone tell me where I'm going wrong?
IanFixed it!
For some reason, the path for certain executables used in replication is stored in the regisry in DOS format, so SQL Server was looking in microso~2 instead of microso~4. I changed this in the registry and everything was fine!sql
Showing posts with label specified. Show all posts
Showing posts with label specified. Show all posts
Wednesday, March 21, 2012
Subscribe to:
Posts (Atom)