Replication subsystems failed to load

  • I am running SQL 2008 Enterprize Edition with SP1 on Windows 2008. I am trying to set up replication. I have completed the following:

    1. Created distribution Database

    2. Created publisher

    3. Granted SQL Agent access to the ...MSSQL\100\Com folder to execute the agent_exe files

    4. Granted SQL Agent access to ...\MSSQL\binn where the subsystem_dll files are located

    5. Granted SQL Agent write permissions to ...\MSSQL\repldata in order the write the bcp files

    Each time I try to initialize the snapshot, I get the following errors in the SQL Agent Log

    1. Log Step.......cannot be run because the LogReader subsystem failed to load. The job has been suspended.

    2. Log Step.......cannot be run because the Snapshot subsystem failed to load. The job has been suspended.

    I found posts where the records in the msdb.dbo.syssubsystems pointed to different folders than where the dll and exe files are located. So, I checked that, but they are correct.

    The SQL Agent has sysadmin on the SQL Server and is using a windows service account.

    I believe it is a security issue because I can run the executables from the command prompt to generate the snapshot for the publication. Have I missed the forest for the trees?

    Any help would be greatly appreciated.

    :crying:

  • FYI. When installing replication after the initial installation, you need to restart SQL Server Agent. That fixed the problem.:-)

  • Thx, was indeed the answer.

  • Yup - restart of the Agent fixed it for me too. Feel like a newb for not thinking of that. 🙂

  • It even works at 4:00am during a really hectic upgrade!!! Thanks!!!!

  • Thanks! This worked for me too. Was spinning my wheels all morning trying to figure this one out. I knew it had to be a simple trick.

  • After 1659 days of this question, still helping.

    Thanks a lot.

  • Saved the day, thanks. SQL agent service restart fixed the problem.

  • Cheers, this worked for me.

  • Much appreciated, this worked for me as well. Wasted 30-40mins looking in various log files.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply