SQL 2008 snapshot replication error: The system cannot find the file specified. The step failed.

I'm trying to set up snapshot replication on SQL Server 2008 32-bit but am receiving an error on the agent stating The system cannot find the file specified.  The step failed..

The system is on Windows 2003 R2 and I've ensured all Windows updates have been applied.  I have disabled publishing and distribution on the server and then re-installed it without any change.

 I am using the default folder C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\repldata and set the permissions so that everyone has full control over it to ensure security is not the issue.  I have also shared the folder and tried installing distribution using \\SERVER_NAME\repldata but again no difference.

Replication has never been set up on this machine previously.
canuckconsultingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ZberteocCommented:
0
canuckconsultingAuthor Commented:
I've set up replication on other machines successfully using but am getting the File not found error on this machine.  Any insight into that would be greatly appreciated.
0
ZberteocCommented:
What is the error exactly?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

canuckconsultingAuthor Commented:
The system cannot find the file specified. The step failed.
0
ZberteocCommented:
What file?
0
canuckconsultingAuthor Commented:
The file is not specified.  Here are screen grabs of the snapshot agent and associated event:

Agent
Event Log
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you already set another replication just verify if there's any replication file missing (snapshot.exe, distrib.exe, logread.exe, *.dll, ...). You may need to fix it manually (copy from another installation) or reinstall the files.
0
canuckconsultingAuthor Commented:
Oh I see...I hadn't thought it was an executable issue.

This is a 32-bit installation while my other servers are 64-bit.  Is there a way for me to re-install the replication feature from the installation media?  I can not see any option to do this via the normal installation user interface.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes. Choose the repair option and check only the Replication feature so it won't touch the engine.
0
canuckconsultingAuthor Commented:
Vitor I'm sorry for the very late reply.

I tried the repair option but there was no option to check on the replication option.  When I did  a full repair it was unable to update the SQL Engine without affecting the production databases so that was skipped.  As  a result nothing has changed.

An interesting development is that I opened a ticket with the MS Partners forum and received the attached advice which advised me to check the paths of agent_exe  in the [msdb].[dbo].[syssubsystems] system table.  Sure enough the paths given do not point to the correct locations.  In fact the file Snapshot.exe  is completely missing which I expect it the issue.  Any thoughts on how I might get that installed?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you have another SQL Server instance that has the same version then copy the file from there.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
canuckconsultingAuthor Commented:
Perfect...thank you!  The only other SQL 2008 server I had was 64-bit but that did not seem to be an issue.  I copied the files across and everything is working great.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.