Replication error....

We try to perform replication. We configured our server for
replication. Steps that we followed:
1) Create Publishing and distribution wizard
2) Create Publication wizard
3) Create Pull subscription wizard
We did not meet any errors until while doing them. But at the end of
the process in the replication monitor red cross signs (As seen in
http://stx.cs.deu.edu.tr/~zbektas/er.JPG ) on the publishers and
subscribers and their status seem as "failed". Why?
We can not start the SQL agent because of "the service did not start
due to a logon failure" error. Is this error related with our
replication failure?
Zafer,
SQL Server Replication infrastructure involves many things including a series of jobs which are scheduled and run by the SQL Server Agent. So, if your agent is stopped, replication won't work. Try changing the SQL Server Agent service to use the same doma
in account as your SQL Server Service and then restart it, and then run the Replication Agents.
Regards,
Paul Ibison
|||This is likely your problem. Locate your SQL Server agent and ensure it is
running with a valid account and password.
"zafer" <zaferbektas2000@.yahoo.com> wrote in message
news:c71dc7b.0404020741.2519351e@.posting.google.co m...
> We try to perform replication. We configured our server for
> replication. Steps that we followed:
> 1) Create Publishing and distribution wizard
> 2) Create Publication wizard
> 3) Create Pull subscription wizard
> We did not meet any errors until while doing them. But at the end of
> the process in the replication monitor red cross signs (As seen in
> http://stx.cs.deu.edu.tr/~zbektas/er.JPG ) on the publishers and
> subscribers and their status seem as "failed". Why?
> We can not start the SQL agent because of "the service did not start
> due to a logon failure" error. Is this error related with our
> replication failure?