Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 7 Replication Errors

Status
Not open for further replies.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top