Guest_imported
New member
- Jan 1, 1970
- 0
Background:
2 SQL 7 Servers running on NT 4.0 SP 6a. One is inside our corporate
firewall and works as a staging area for Web DB Content. Every 12
hours, a transactional db replication occurs to push the changed data
through the firewall to another identical SQL server that drives the
corporate web site.
Issue:
A little over a week ago, replication stopped working. We are now
getting the following error message in the log reader:
"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."
I have checked the access permissions and password for the account
that the SQLServerAgent Service uses on both servers and they are
correct. I even tried creating a new account on both servers with the
right access and made no progress.
I even tried using the DCOMCNFG utility as suggested in the error
message with no success.
Does ANYONE have ANY information that may help me resolve this
problem? All web updates are now stalled because of this.
Thanks in advance,
Ian Pitts
Group 1 Software
2 SQL 7 Servers running on NT 4.0 SP 6a. One is inside our corporate
firewall and works as a staging area for Web DB Content. Every 12
hours, a transactional db replication occurs to push the changed data
through the firewall to another identical SQL server that drives the
corporate web site.
Issue:
A little over a week ago, replication stopped working. We are now
getting the following error message in the log reader:
"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."
I have checked the access permissions and password for the account
that the SQLServerAgent Service uses on both servers and they are
correct. I even tried creating a new account on both servers with the
right access and made no progress.
I even tried using the DCOMCNFG utility as suggested in the error
message with no success.
Does ANYONE have ANY information that may help me resolve this
problem? All web updates are now stalled because of this.
Thanks in advance,
Ian Pitts
Group 1 Software