Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-11 : 23:12:12
|
Angie writes "We have are using the MS-SQL7 Server replication to push database information across the firewall to a replicated database for our corporate web site. This had been working fine for months. Now it has stopped working for no apparent reason. The error message that appears in the sysjobhistory logs is:
"SQL Server Agent could not access the replication agent. Use the DCOMCNFG utility to confirm that the SQL Server Agent NT account has permissions on the replication agent. The step failed. [SQLSTATE 42000] (Error 14151)."
There were no hardware or software additions or modifications, permissions and NT accounts are still active, shutdown and restart did not help, reinstalling SP3, and recreating the replication jobs and agent did not resolve the issue. The Website is successfully pulling data from the replicated database, however, we can not push new or updated data out to said database.
We have been unable to find any references to this error message. This is week two since the replication process stopped working.
Can you give us an explanation for what may be causing issue? (We are using NT 4.0 with IIS 4 for the Web Server, SQL7 for the Database and Replication). Thanks." |
|
|
|
|
|
Replication Issue: SQL Server Agent unable to access the Replication agent.